WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Since updating OS X I can no longer access my SQL databases (7 posts)

  1. station8design
    Member
    Posted 4 years 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.

  2. ClaytonJames
    Member
    Posted 4 years ago #

    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?

  3. station8design
    Member
    Posted 4 years ago #

    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.)

  4. ClaytonJames
    Member
    Posted 4 years ago #

    Could you open a terminal see what this returns...

    ]$ mysql --version

  5. ClaytonJames
    Member
    Posted 4 years ago #

    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!

  6. station8design
    Member
    Posted 4 years ago #

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

  7. ClaytonJames
    Member
    Posted 4 years ago #

    Excellent... I'm glad that solved the issue for you!

Topic Closed

This topic has been closed to new replies.

About this Topic