Can you rule out *everything* that is mentioned in the error message?
Michael
Thread Starter
beuys
(@beuys)
——————————————-
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?
If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.
——————————————————
This is the complete message …
i cant see what i could have done wrong ..
maybe instead of local host another adress????
Well, typo in the username, password etc. can cause this error as well. That’s why I was asking. localhost should be fine if your MySQL server is running on the same machine.
Thread Starter
beuys
(@beuys)
This is what I filled in to the wp-config.php:
——————————————————–
<?php
// ** MySQL settings ** //
define(‘DB_NAME’, ‘wordpress’); // The name of the database
define(‘DB_USER’, ‘cedis’); // Your MySQL username
define(‘DB_PASSWORD’, ‘lione5’); // …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. */
define(‘ABSPATH’, dirname(__FILE__).’/’);
require_once(ABSPATH.’wp-settings.php’);
?>
—————————————————-
is there anything wrong?
No, seems being OK if both the MySQL DB and the webserver are on the same machine. But do you have a database named “wordpress”? No typo in username and password?
I am asking just in case, and I assume in 99% of this error a typo is the cause (Once in a while I also get such messages due to a typo or misconfigured MySQL user)…
Also, does the MySQL user ‘cedis’ have appropriate access to this database?
BTW: if this is your real data, you should remove it in this post to avoid having someone access to your MySQL database & you should change your MySQL password.
I’m having the same problem “Error establishing a database connection”. However, I’ve made sure my msql database is running, php is up and running, and my wp_config.php file has the exact values I used in setting up mysql.
define(‘DB_NAME’, ‘wordpress’);
define(‘DB_USER’, ‘root’);
define(‘DB_PASSWORD’, ‘password’); – I changed the password to my mysql password.
Any thoughts?
Thread Starter
beuys
(@beuys)
yep, i can change the username and database-name whenever I want. I will do so when I have everything running …
But still I have this problem … What do you mean with typo????
you can see username (cedis) and databasename (wordpress)
there is no “typo” in it … or what do you mean?
@beuys: With typo I mean:
If the database name is e.g. “wqrdpress”, but you have entered “wordpress” in the wp-config… Note the “q” instead of the “o”. What I mean is to double-check every letter you have entered.
@beuys and washburnhead:
Just a shot in the dark:
I’ve had an issue very recently: Installed MySQL 5, created a user, but didn’t have access via PHPMyAdmin. to the database. I needed to change a MySQL option to enable “Use old passwords”. After that, I needed to change the user’s password again and then it worked.
Thread Starter
beuys
(@beuys)
i´m sure i got the correct spelling, because I copied and pasted the words directly from the database-interface ..
to change mysql-options sounds pretty complicated to me …
E.g. here is being described how to change the option. (search for USE OLD PASSWORDS in the text).
Michael,
How do you change the MySQL option to enable “Use old passwords”? The MySQL password currently is the one I set using, /usr/local/mysql/bin/mysqladmin -u root password <yourpasswordhere>
I am using MySQL Administrator, IMHO a must-have tool for MySQL.
Uh, ok. I now have MySQL Administrator v.1.1.3 but I have no idea what I’m doing now. I’ve been fishing around for how to change the option to enable “Use old passwords” but nothing popping out at me?
Does it matter that the Server MySQL version and the Client MySQl version do not match? Server version is 4.0.2 and the client version (even though I installed the package for 4.0.2) says it’s 5.0.10. Strange?
Thread Starter
beuys
(@beuys)
Ok, now I installed a new database and everything is working fine …. so there must have been some mistyping, but still I couldnt find out what I made wron before …
so thanks for your help …
beuys
My issue still not solved, I am using MYsql5.0.13 with PHP 4.42 I am still getting 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.
Is there is a bug
What is the recommended version of mysql and PHP with download url ?Can anyone please simplify me
