OS X V10.7 Lion :: Installing DBD::MySQL On 10.7.3?
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
ADVERTISEMENT
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
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
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
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
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
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
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 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
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
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
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
Mar 24, 2012
I have a 2010 mini that shipped with Snow Leopard. I hooked up to my TV with display set at 1080p and had no problems for a year and a half. I just installed Lion, though, and a few times now, when the computer wakes up from sleep, it has changed to a lower resolution. I can go back into System Preferences and change it back, but I don't think I should have to. This is a Mac, after all.
Info:
Mac OS X (10.7.3)
View 1 Replies
View Related
Feb 15, 2012
After re-installing Lion, my login accounts disappeared.I can only see the Guest account.However, when I boot with Windows, I can see the directories of my accounts.Currently, I can't login Mac OS.
Info:
MacBook Pro (13-inch Early 2011), Mac OS X (10.7)
View 3 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
Jul 3, 2012
Unable to connect to the database:Could not connect to MySQL I just started to receive this message, when I try to go to this one website. What caused this? and how can I fix this problem? I an geet to website using other browsers.
Info:
iMac, Mac OS X (10.0.x)
View 4 Replies
View Related
Feb 3, 2012
I have downloaded OSX updated 10.7.3 through software update. Once it has downloaded I follow instructions to restart and install the update. My macbook shuts everything down and lands up at the login screen. Please help to install this update
Info:
MacBook, Mac OS X (10.7.3)
View 4 Replies
View Related
Feb 6, 2012
I have a problem with installing the 10.7 upgrade, it basically keeps showing the below error
Info:MacBookPro, Mac OS X (10.6.8)
View 1 Replies
View Related
Feb 13, 2012
i wanna install windows on my macbook but i don't know if parallel comes with windows and everything or do i have to buy windows separately ?
Info:
MacBook Pro, Mac OS X (10.7.3)
View 1 Replies
View Related
Feb 14, 2012
Startup and shutdown is taking long time....if u know any solution then reply...
Info:MacBookPro, Mac OS X (10.7.3)
View 6 Replies
View Related
Apr 2, 2012
I have a 500 GB Hard drive in my early 2011 MacBook Pro and will be adding a a second SSD Drive in the former location of my optical drive. I purchased a 64GB SSD and only want to transfer the operating sytem and apps. How can I do this? I am familiar with super duper but think that only exact copies can be made. Is there any other way that I can transfer just Mac OSX Lion and my Apps to my new hard drive?Â
Info:
MacBook Pro (15-inch Early 2011), Mac OS X (10.7.3)
View 1 Replies
View Related
Apr 9, 2012
how to install the Lion OS on more than one computer? I downloaded and installed Lion on my iMac today, but want to do the same for my other two computers as well. Is there a way to find the DMG file and save it onto a flash drive instead of downloading it all over again? I searched using Spotlight and could not find the downloaded file anywhere.Â
Info:
iMac, Mac OS X (10.7.3)
View 1 Replies
View Related
May 17, 2012
I am trying to update my iMac from Snow Leopard to Lion via a purchased download. The first time it wouldn't install because it said the disk was corrupted and needed to be wiped. So I wiped it and restored to the starting position, did disk repair (all fine). Downloaded it again, after several failed attempts. Finally got it to download and install only to discover it wasn't working properly - Mail for instance didn't work - and used OSX recovery to reinstall, which downloaded "components" for 8 hours and then I got a big yellow triangle warning saying "installation failed." Â
I have used up all my high speed internet connection allowance for the month trying to do this, and am now back on a restored version of Snow Leopard. Any advice gratefully received! I simply don't have the ability or patience to try to download another 4GB.
Info:
iMac (24-inch Mid 2007), Mac OS X (10.6.8)
View 3 Replies
View Related
Jun 16, 2012
I recently tried to wipe my HD and reinstall OSX Lion again to wipe my computer and start again. But now i am having difficulty installing Lion again as when i reset my MacBook Pro it comes up with the internet recovery and the option to reinstall OSX Lion.Once i click on that option it says its verifying the update with apple, then comes up with an error message saying an error occurred while preparing the installation please open application again. Or something along those lines this effectively leaves my computer unusable as i cannot do anything else with it.
Info:
MacBook Pro (15-inch Mid 2010), Mac OS X (10.7)
View 6 Replies
View Related
