Mac OS X 10.4.4 MySQL connection problem and solution

  • Resolved amelgares

    (@amelgares)


    18 years, 3 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)

    18 years, 3 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)

    18 years, 3 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)

    18 years, 3 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)

    18 years, 3 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)

    18 years, 3 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)

    18 years, 3 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)

    18 years, 3 months ago

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

    dcurry

    (@dcurry)

    18 years, 2 months ago

    thanks a million for the post!

    zebra

    (@zebra)

    17 years, 10 months ago

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

    symbol

    (@symbol)

    17 years, 10 months ago

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

    jabarig

    (@jabarig)

    17 years, 8 months ago

    huge help amelgares. Thanks alot

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Mac OS X 10.4.4 MySQL connection problem and solution’ is closed to new replies.