WordPress › Support » Error establishing a database connection

beuys
Member
Posted 3 years ago #

hi
i installed wordpress today, installed the mysql database on my server and filled in the database information to the wp-config.php (after i renamed that file to wp-config.php)

if i go to
http://cedis.port07.de/wordpress/wp-admin/install.php

I only get this message: Error establishing a database connection,

I dont know why ... I have running typo3, moodle woltlab-forum on php and all are working fine ...

Where could be the failure ? whats wrong with me?

hopefully waiting for answers
----<---<#@
beuys
Michael_
Member
Posted 3 years ago #

Can you rule out *everything* that is mentioned in the error message?

Michael
beuys
Member
Posted 3 years ago #

-------------------------------------------
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????
Michael_
Member
Posted 3 years ago #

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.
beuys
Member
Posted 3 years ago #

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?
Michael_
Member
Posted 3 years ago #

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.
washburnhead
Member
Posted 3 years ago #

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?
beuys
Member
Posted 3 years ago #

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?
Michael_
Member
Posted 3 years ago #

@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.
beuys
Member
Posted 3 years ago #

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 ...
Michael_
Member
Posted 3 years ago #

E.g. here is being described how to change the option. (search for USE OLD PASSWORDS in the text).
washburnhead
Member
Posted 3 years ago #

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>
Michael_
Member
Posted 3 years ago #

I am using MySQL Administrator, IMHO a must-have tool for MySQL.
washburnhead
Member
Posted 3 years ago #

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?
beuys
Member
Posted 3 years ago #

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
hillman
Member
Posted 3 years ago #

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

Topic Closed

This topic has been closed to new replies.

WordPress.org

Forums

Error establishing a database connection (16 posts)

Topic Closed

About this Topic

Tags

Code is Poetry