Since updating OS X I can no longer access my SQL databases

  • Resolved station8design

    (@station8design)


    14 years, 3 months ago

    Since updating my MacBook’s operating system from Leopard (10.5) to Snow Leopard (10.6) the WordPress test sites on my computer no longer work. When I go to them using my web sharing through Apache I just see “Error establishing a database connection”.

    This is an improvement from before when they didn’t work at all. I got some help at Apple’s discussion boards (See posts here). To summarize, per the advice from a board member, I updated MySQL to the latest version and had to enter some commands through the terminal. I can see all of my databases using Sequel Pro as well as add users. However, I can’t flush privileges and only see this error “MySQL said: Table ‘mysql.servers’ doesn’t exist”

    I’ve got some very urgent projects I need to work on and this has held me up for a week trying to get it straightened out. Any advice would be helpful.

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

  • Could you clarify this please:

    “the WordPress test sites on my computer no longer work. When I go to them using my web sharing through Apache I just see “Error establishing a database connection”….
    …This is an improvement from before when they didn’t work at all”

    Were the wordpress sites working correctly prior to upgrading OSX or were they not working at all?

    Thread Starter station8design

    (@station8design)

    The WordPress test sites were all working properly prior to upgrading.

    After upgrading, MySQL wasn’t available at all and none of my sites loaded. I had to install the latest version of MySQL then copied the data folder from the old MySQL folder to the new MySQL folder. (Per instructions from the guy helping me out at Apple Discussions.)

    Could you open a terminal see what this returns…

    ]$ mysql –version

    Here is a link that might at least send you towards a fix. I can’t say for sure, and I know the article references OSX 10.5 versions, but I have read similar issues with Snow Leopard and MySQL that were relative to the topic being discussed. There seems to be a lot of issues out there with mysql and 10.6.

    Also – if you have mysqladmin available on your mac, you can open a terminal and use

    ]$ mysqladmin

    or

    ]$ man mysqladmin

    to return the users manual for mysqladmin. That might be of some help as well.

    Good luck to you!

    Thread Starter station8design

    (@station8design)

    That article did the trick! Once I changed the MySQL socket location and restarted Apache, everything was working properly again. Thanks!!!

    Excellent… I’m glad that solved the issue for you!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Since updating OS X I can no longer access my SQL databases’ is closed to new replies.