I am going through the setup procedure, but I keep getting "Error establishing a database connection" when I try to runn the "install.php" script. I can connect to the database from the command line with the same information that is in wp-config.php:
mysql -h localhost -u wordpress wordpress -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 129054 to server version: 4.0.18-Max-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
I can also run "php install.php" and it talks about going through some steps, so I know that php can access the database from the command line.
Here are the versions I'm running:
mysqld Ver 4.0.18-standard for pc-linux on i686 (Official MySQL RPM)
PHP 4.3.2 (cgi), Copyright (c) 1997-2003 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies
I am using php with squirrelmail just fine and mysql is working with postfix. What I'm struggling with is finding out exactly where the connection is failing. I see the connection attempts in query.log for both sucessful and purposefuly unsuccessful (ie mistyped password) when I connect from the command line. I also see a great deal of output in query.log when I run "php install.php" from the command line, so again, I know that a connection is being established that way. However, I don't see any attempts at connections (failed or otherwise) in query.log when I run install.php from the web. Is there some way to turn on some sort of logging within php or wordpress to see why exactly the connection attempt is dying?
Here's my wp-config.php with the password blanked out:
// ** MySQL settings ** //
define('DB_NAME', 'wordpress'); // The name of the database
define('DB_USER', 'wordpress'); // Your MySQL username
define('DB_PASSWORD', '######'); // ...and password
define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value
// You can have multiple installations in one database if you give each a unique prefix
$table_prefix = 'wp_'; // Only numbers, letters, and underscores please!
// Change this to localize WordPress. A corresponding MO file for the
// chosen language must be installed to wp-includes/languages.
// For example, install de.mo to wp-includes/languages and set WPLANG to 'de'
// to enable German language support.
define ('WPLANG', '');
/* That's all, stop editing! Happy blogging. */