Wordpress problem on OS X Server 10.4.1

[mtbikemj]

I'm getting the same "Error establishing a database connection" message. I have a fresh install of Mac OS X Server with all updates. I have the web server service started with the PHP enabled. Any ideas? Thanks!


details here:
http://wordpress.org/support/topic/34738

[dhayton]

Have you tried manually resetting your password? I had this problem and issued the following command and have had nothing but joy since:

mysql> SET PASSWORD FOR 'username'@'host' = OLD_PASSWORD('newpassword');

Obviously, replace username, host, and newpassword as appropriate.

best,
darin

[iVoltage]

I've just sorted this one out myself. It seems PHP and MySQL don't communicate properly out of the box using Tiger Server. Here's what to do:

1. Fire up MySQL Manager (Applications/Server/MySQL Manager) and ensure MySQL is installed. Also double check the PHP4 module is enabled in your Apache settings. If it isn't, enable it and restart the service.

2. Start up MySQL. We need to ensure that a particular SQL directory is created so we can tweak it later on.

3. Open Terminal and type sudo cp /etc/php.ini.default /etc/php.ini

4. Open /etc.php.ini in your a text editor and add /var/mysql as the default MySQL socket. It should read:

mysql.default_socket = /var/mysql/mysql.sock

5. PHP should now know where to look. Make sure the directory can be read: sudo chmod 755 /var/mysql and close your text editor.

6. Type mysql -h localhost -u root -p and enter the root password.

7. Replacing the coloured text with your own choices, at the MySQL prompt, type:

CREATE DATABASE wordpress;
GRANT ALL PRIVILEGES ON wordpress.* TO word@localhost IDENTIFIED BY 'password';
SET PASSWORD FOR word@localhost = OLD_PASSWORD('password');
FLUSH PRIVILEGES;

8. Point your browser to http://localhost/wordpress/wp-admin/install.php (or wherever install.php resides in WebServer/Documents). Finally, hit return and pray.

Sorry for stating the obvious here but I figured it would make the post easier to follow for people with no experience of the CLI (like me, last week).

Good Luck!

[mtbikemj]

That worked! YOU RULE! One more note, restart webserver before you pray!

[philaweb]

Quote: Originally Posted by iVoltage 4. Open /etc.php.ini in your a text editor and add /var/mysql as the default MySQL socket. It should read: mysql.default_socket = /var/mysql/mysql.sock

Thanks for solving this problem!

Please tell me, how could you edit the /etc/php.ini file in an ordinary text editor?
The file is normally not writeable.

[j0nathan]

This thread is linked to from the WordPress forums (http://wordpress.org/support/topic/34738) which also highlight another potential problem / solution.

The above didn't work for me however changing DB_HOST to 127.0.0.1 rather than localhost seemed to work.