Mac OS X 10.4.4 MySQL connection problem and solution

Resolved amelgares
(@amelgares)

20 years, 5 months ago

So of course I went ahead and upgraded my two Macs to 10.4.4 and my WordPress 2.0 and mySQL 4.1.15 systems stopped working with the can’t connect to mysql datasource error.

To fix this, this is what I had to do on two machines running Mac OS X 10.4.4 (client, not server):

cd /etc
sudo cp php.ini.default php.ini

then edit the php.ini file so that the “mysql.default_socket” line is:

mysql.default_socket =/tmp/mysql.sock

save the file

sudo apachectl restart

and my wordpress blog was back in action.
I’m not sure if this is some odd thing that just hit my two Macs, but thought this could be of some help to others.

Viewing 11 replies - 1 through 11 (of 11 total)

restiffbard
(@restiffbard)

20 years, 5 months ago

Brilliant. Thanks mate. Fixed things before I was even sure there was a problem. If that’s the biggest bug in 10.4.4 then things should be fine here out.

ajgiunta
(@ajgiunta)

20 years, 5 months ago

Thank you, thank you, thank you. I upgraded my PowerBook last night, which I keep a local copy of WordPress on to tinker with, and it broke. I spent all morning stumbling through MySQL trying to find the problem. I knew I should have checked here first. Now I can safely upgrade my server. Thanks again!

hanlon_bf
(@hanlon_bf)

20 years, 5 months ago

Hi

Tried the solution but I am unable to save the php.ini file when I’ve made the changes. Pico gives the msg “could not open file for writing: Permissions denied”. I’ve had a couple of tries following the above instructions.

Any suggestions appreciated.

scottganyo
(@scottganyo)

20 years, 5 months ago

amelgares: you rock!

hanlon_bf: just set the file to writable before editing:

>sudo chmod +w php.ini
>sudo pico php.ini

restiffbard
(@restiffbard)

20 years, 5 months ago

hanlon, don’t set the file to writable. it should already be writable.

your problem is a matter of permissions. the file you’re trying to edit is owned by root. Just editing with sudo pico php.ini should be enough. You’ll be asked for your system password and then be off to the races.

not trying to say you’re dumb, can’t make assumptions about what you know about the terminal, sudo is the command to tell the system that you wish to behave as the super user (aka root).

JohnL
(@johnl)

20 years, 4 months ago

amelgares, nice solving. I’d spent time poking around to see whether mysql was running (ps -aux | grep 'mysql'), there were permission problems with mysql data and the error log, how Apple had modified my httpd.conf, whether /tmp/mysql.sock was present, etc. Had I consulted your solution before doing all the other stuff, I’d’ve been finished 45 minutes ago. Thanks.

JohnL

hanlon_bf
(@hanlon_bf)

20 years, 4 months ago

restiffbard, thanks for the extra tip it worked. Not that I’m saying I’m dumb just ignorant 🙂

dcurry
(@dcurry)

20 years, 4 months ago

thanks a million for the post!

zebra
(@zebra)

20 years ago

remember create mysql user, put rights to socket file and then all will work ok

symbol
(@symbol)

19 years, 12 months ago

i have the same problem but ony reinstall from yast, reboot and ready. thanks for all post.

jabarig
(@jabarig)

19 years, 10 months ago

huge help amelgares. Thanks alot