Well its not new, asked many times by other users...still I'm facing the same problem of error message "Error establishing a database connection" while trying to install wordpress using xampp as localhost.
I've done everything from configuring wp-config.php file to setting up 'wordpress' name database and a user for it. Also have checked these things again and again in hope to resolve this issue, though its :(
So here is what I've done in wp-config.php:
// ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'wordpress'); /** MySQL database username */ define('DB_USER', 'root'); /** MySQL database password */ define('DB_PASSWORD', ''); /** MySQL hostname */ define('DB_HOST', 'localhost'); /** Database Charset to use in creating database tables. */ define('DB_CHARSET', 'utf8'); /** The Database Collate type. Don't change this if in doubt. */ define('DB_COLLATE', '');
I wish, I could show you database and its user settings through images, but no facility given here.
So after running xampp both Apache & MySQL, able to access successfully the database @ "http://localhost/phpmyadmin/index.php"
I'm receiving error message "Error establishing a database connection" on both two ocassions:
First, when I try to access following url:
Second, when I try to access this url:
One IMP note, I've installed XAMPP in my D: drive. Does this make any difference.
Can somebody help me please!