Software :: Installing MySQL For Leopard 10.5?
Dec 17, 2008
I am attempting to install MySQL for my Mac.
First, let me say that I attempted to install it using Termnial, but I messed up horribly and got very confused. Therefore I partitioned my HD and started over.
I want to use a GUI to avoid scrambling something in Terminal again, as well as it being easier on the eyes. I have downloaded the two DMG's directly from the MySQL site:
mysql-5.0.67-osx10.5-x86.dmg
mysql-gui-tools-5.0-r12-osx10.4-universal.dmg
I installed the GUI no problem, but MySQL is another thing.
Is it as easy as just installing the packages in the dmg, as well as the prefpane? Or do I need to do some Terminal work as well?
My motivation for attempting to install MySQL is so I can have access to Retrosheet files [URL]. These files are baesball statistics that can be imported into mysql. Ultimately, I would like to be able to use the Game Logs (Link) and query them through MySQL.
View 2 Replies
ADVERTISEMENT
May 7, 2012
I have Xcode 4.3.2 downloaded from MacApp store. However, it didn't set my environment for development libraries at all. So I included /Applications/Xcode.app/Contents/Developer/usr/bin/ in PATH so it can find common utilities like make, cc, etc. I have installed mysql-5.5.23-osx10.6-x86_64 from MySQL's DMG archive. That went smooth - I am able to start and stop the server. Get in using mysql command line client interface and execute queries, etc. Perl came preinstalled with 10.7.3 Lion. Version of perl is 5.12.3. I am now trying to install DBD::MySQL driver for interfacing with perl and ran into issues. According to MySQL documentation, I first tried to install this driver using -
shell> perl -MCPAN -e shell
cpan> force install DBD::mysql
But this failed with make errors (the error is same as reported further below). Then, after days of googling, I found the original post by etresoft on installing this driver. I followed the steps documented in that post (reproduced below for easy reference). My comments in italics. Download the MySQL Perl driver. Done. My version of DBD happens to be 4.021.
Extract the archive with:
tar xvf DBD-mysql-4.021.tar
Move into the directory:
cd DBD-mysql-4.021
First, fix the MySQL client library. (credit) For Lion, type:sudo install_name_tool -id /usr/local/mysql-5.5.14-osx10.6-x86_64/lib/libmysqlclient.18.dylib /usr/local/mysql-5.5.14-osx10.6-x86_64/lib/libmysqlclient.18.dylib Done. No issues.
[code]....
Info:
iMac, Mac OS X (10.7.3)
View 5 Replies
View Related
Apr 13, 2012
I am attempting to install MySQL on my iMac. I downloaded the DMG packages and instaled them, then the instructions I was following from this [URL]. It told me to install a mysql connector (I am new to all of this so I dont know what a mysql connector is). This did not have a DMG package available, so I downloaded the tar.gz as it was my only option. Following the instructions I opened terminal and entered the following command (as shown in image above): sudo pico /etc/my.cnf. I am concerned about the warning message - this is a work computer and I cannot afford to replace it if something gets screwed up.
Info:
iMac, Mac OS X (10.7.3)
View 2 Replies
View Related
Mar 13, 2012
mysqld has a ton of really nice startup options to help me debug my app. However I cannot figure out how to shutdown and restart MySQL from the command line and pass these options to mysqld.Snow Leopard and MySQL 5.1.56 MySQL Community Server.
Info:
MacBook & MacAir & iMac, MacAir 10.5.x -- iMac 10.6.x
View 6 Replies
View Related
Apr 20, 2012
Trying to installed JAMF software on Mac Mini server. One of the configuration steps required setting up a database from the terminal but it requires the MYSQL service to be running and I'm unable to get this service to start.
Info:
Mac mini, Mac OS X (10.6.3)
View 1 Replies
View Related
May 19, 2012
Server version is: 5.0.8 Current available seems to be : 5.5.24 community server available from h [URL]if I already have several databases running under 5.0.8 what are the hazards with upgrading to 5.5.24 community server?
Info:
Mac mini, Mac OS X (10.6.8)
View 1 Replies
View Related
Apr 14, 2008
I just bought a new Macbook Pro 2.4 and starting fixing it with only fresh installs. I installed the OS X 10.5 (x86_64) pak. It was running fine until now.
The start/stop in the pref.pane don't work and if I do a "mysql start" in the terminal I get:
Quote:
MacBookPro:~ matsaki$ mysql start ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I tried to reinstall but it did not help. What's bugging? And what to do?
View 7 Replies
View Related
Feb 10, 2010
I downloaded a the newer version directly from mysql and made a install. Now I can't stop mysql from running. I throw away the strat/stop in prefpane too. But as soon as I stop mysql it restart's after 3 seconds??
I am wondering if I have 2 mysql running also. The original in the box and the new one. Now I'm at a stage where I have to solve this problem and I am truly not good with UNIX andMySQL commands to see what's wrong or what to do.
Again I almost don't know anything how to use the terminal.
View 7 Replies
View Related
Sep 18, 2010
I'm looking for a Mac desktop application that will allow me to edit MySQL databases that are located on a web server. Kind of like PHPMyAdmin, only as a desktop Mac application.
Do any such applications exist?
View 3 Replies
View Related
Dec 11, 2008
I've been looking for a nice way to synchronize MySQL databases in a quick and easy way on the Mac, but so far I haven't found any good options.
Since I'm doing my development locally on both my iMac and my MacBook I'd like to be able to sync the site I'm working on with a click of a button.
There are very nice file syncing tools available (I'm currently using Synk Standard), but as far as MySQL syncing (two-way) goes the only one I've found is Navicat.
While Navicat works great they have for some reason not made it possible to access from the command line in the mac version, which means that I can't run the db sync automatically when I run the file sync.
I've tried UI scripting but it just won't work reliably (it clicks in the wrong places all of the time).
So do you know about any good MySQL syncing tools, that sync in both directions and are scriptable?
View 6 Replies
View Related
Mar 24, 2009
I am trying to create on my Macbook a mysql account but it doesnt allow it. I suspect it is the same one in the "/etc/passwd" file: _mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false I am curious though why in that same file I dont see my normal login account. Where is the 2nd list of users? Is it a plist file somewhere? Also anyone know of a utility that shows all the users including root and all the other special accounts in one place?
View 1 Replies
View Related
Apr 25, 2009
I had previously downloaded MySQL on my computer. However, I discovered MAMP and want to use it. When I try to "Set to default Apache and MySQL ports" in the preferences form, Apache starts back up but MySQL doesn't and then my web program won't recognize my local server. What can I do to fix this?
View 2 Replies
View Related
May 10, 2012
I'm unable to connect to mysql. I receive the following error when attempting to connect:
<username>: -> mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
I installed mysql-5.5.23-osx10.6-x86_64 using the user tip located at [URL].
Info:
Mac Pro, Mac OS X (10.7.3)
View 4 Replies
View Related
Sep 4, 2014
I was running on Mac 10.6.8 and I wanted to update to Mac 10.9, which I did. I am not discovering that there have been some issued with Apache2 and my localhost. I don't know what is wrong, but I got it working once again.
Now I am having a rather large issue with MySQL. That issue being that it's no longer on my computer. mysql is no longer a bash command, and it's not in my /var/lib/ directory, not is it anywhere else I looked. I had a few databases set up, and I don't know if they were deleted somehow or what. I can't connect via Sequel Pro either. Must I completely reinstall MySQL for it to work again, or is some stuff still recoverable?
Info:
MacBook Pro, OS X Mavericks (10.9)
View 4 Replies
View Related
Oct 17, 2009
I have a tower Mac Pro with Snow Leopard running on it.Unfortunately one of the software that I use doesn't have yet a Snow Leopard update. So I am thinking maybe I can install older version of Leopard on one of the internal drives (i have 3 additional internal drives), so I can boot my computer from either Leopard or Snow Leopard, depending on needs (i don't want to get rid of Snow Leopard).
I never installed OS X system before, so I am a bit scared.The internal drive is ready, I have the old Leopard on disks, what are the next steps to take?
View 3 Replies
View Related
May 18, 2012
I have downloaded 10.5.8 combo several times and cannot get it to install because the disc won't mount or the installation gets hung up after restart. My current os is 10.5.1, and I am trying to upgrade to snow leopard. This is on a dual core macbook pro.
Info:
MacBook Pro (15-inch 2.4/2.2 GHz), Mac OS X (10.5.1)
View 1 Replies
View Related
Mar 13, 2012
However I cannot figure out how to shutdown and restart MySQL from the command line and pass these options to mysqld.
Snow Leopard and MySQL 5.1.56 MySQL Community Server.
Info:
MacBook & MacAir & iMac, MacAir 10.5.x -- iMac 10.6.x
View 1 Replies
View Related
Jun 30, 2012
I use the normal command line and i get this message.
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Info:MacBookPro, Mac OS X (10.7.4)
View 2 Replies
View Related
Nov 26, 2008
Question in the title - just wondering if I will need to upgrade to Leopard before Snow Leopard.
View 3 Replies
View Related
Nov 19, 2009
Every time i stop MySQL from the pref pane it restarts after 30 sec. I don't have a clue why. Anybody who can help me how to find why?
View 5 Replies
View Related
Apr 15, 2012
mysql unable to connect; MySQL said: Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
Info:
Mac mini, Mac OS X (10.7.3)
View 10 Replies
View Related
Jun 11, 2012
Macbook Pro running Lion V 10.7.4 .After a hard drive failure this weekend, I restored frm my most recent backup.Unfortunately this did not include svn, host file changes and some other fairly easy to correct things.The one that has been giving me trouble for the last 8 hours is mysql. I have gone through and removed mysql (multiple times) and did fresh installs. Each time I was getting the error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (38)
Even after changing my /etc/my.cnf file to point to var/lib/mysql/mysql.sock I would get these errors.
Are there multiple locations where mysql points to /tmp/mysql.sock?
I am at a loss of what to do. I have uninstalled reeinstalled. Tried many different solutions all to reeive the same error.
Info:
Mac OS X (10.7.4)
View 4 Replies
View Related
Dec 21, 2010
I'm trying to install Mac OS X Snow Leopard on to my macbook but I keep getting this error.
"mac os x installation couldn't be completed" I get this message usually within 5 minutes of installation.
My macbook specs are...
Mac OS X Version 10.5.8, 2.16 GHz Intel Core 2 Duo, 1 GB 667 Mhz DDR2 SDRAM
I've already tried repairing the disks. (I repaired my leopard with the snow leopard CD because I couldn't find the leopard CD.
I heard it was fine to do.) I would have tried to verify and repair the partition but the buttons seemed to be grayed out for some reason.
Here is the error log...
[URL]
(sorry for the download, forum rules. "the text that you have entered is too long (123483 characters). Please shorten it to 20000 characters long.")
View 2 Replies
View Related
Jul 8, 2009
Will it install like the OS does on the iPhone, as in the existing data isn't put in a new folder? What exactly happens when you install a new OSX?
View 1 Replies
View Related
Oct 28, 2007
Is there any way to work around this problem:
I just bought the Leopard family pack for my Mac Pro and my 1 Ghz PowerBook 12". I loaded Leopard onto the Mac Pro with no problem--but when I tried to install it on the PB 12", I discovered that my PowerBook's DVD player has died. (There had been some indications of flakey behavior over the past few months, and none of the other DVDs I tried would work--they would just get ejected.)
My question is this: is there any other way to install Leopard onto my PB without using the DVD? I do have a working DVD player on the Mac Pro, as well as a myriad of hard drives and iPods that could be used in disk mode.
View 11 Replies
View Related
Dec 12, 2008
i have windows vista right now and it gives me nothing but grief. I cannot afford a Mac however if i buy leopard online and if i was to wipe windows of my PC completly would i be able to install leopard and run the computer as a mac?
View 11 Replies
View Related
Jan 26, 2009
I'm trying to narrow down a leopard installation to about 4.7 GB to fit on a DVD.
What directories do i not need, but come with the installation anyways?
View 10 Replies
View Related
Feb 10, 2009
i recently purchased an intel imac off craigslist. i want to do a fresh install of leopard on it (it already has leopard installed, i just want to get all the old info and programs off of it). the problem is that it didn't include any of the original discs. i know that technically i should buy a retail version of it but i don't feel morally obligated to since it already had leopard legally installed (flame if you must). i don't want to go to the time and effort to download a copy of the dvd from various unsavory sources so what i'm wondering is if it's possible to make a bootable partition on an external drive from one of my other macs then copy it onto the imac. and if so, how?
View 14 Replies
View Related
Mar 11, 2009
So after I install the SSD and the RAM, do I just insert the Leopard CD when it boots up? Do I have to press any keys?
View 6 Replies
View Related
Feb 4, 2010
I'm wondering if it is possible to install different MAC OS versions (for example, having Leopard and Tiger OS X) on the same computer, as you usually do with different versions of Windows just making some partitions. Is it possible? If yes... how?
View 5 Replies
View Related
