I'm trying to set up WordPress on my site, signalstation.com (in a subdirectory, 'signal'.) But for a package with such a famously easy installation, it's been a real pain for me.
I finally got the MySQL stuff whipped into shape, but when I tried to go to the install page, I got this error.
Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at localhost. This could mean your host's database server is down.
* Are you sure you have the correct username and password?
* Are you sure that you have typed the correct hostname?
* Are you sure that the database server is running?
I asked my host, and 'localhost' is correct. The database server is running-- I can access everything through phpAdmin.
Here's my wp_config.php file:
// ** MySQL settings ** //
define('DB_NAME', 'signal_wp'); // The name of the database
define('DB_USER', 'signal_station'); // Your MySQL username
define('DB_PASSWORD', '******'); // ...and password
define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value
// Change the prefix if you want to have multiple blogs in a single database.
$table_prefix = 'ss_'; // example: 'wp_' or 'b2' or 'mylogin_'
The signal_station user has all privileges.
Is it causing a problem to change that table_prefix value? I'm probably going to want multiple blogs in time.
I hope someone can help. This is really frustrating. Thanks for your time.