This could be a long shot but I was wondering whether anyone knows anything about getting the xampplite database connected to wordpress? I have already been to the wordpress forum but not having much luck getting an answer there.
I have followed a step by step instruction to install both software and the first time it worked well, but I had to uninstall due to template errors. And now I cannot at all get the database to connect up for some odd reason, but xampplite runs well.
I have checked the below steps:
- If you have a db connection problem then something is amiss.
- Make sure that the db user you created has "all" privileges
- Make sure you have entered the right info into wp-config.php
- Then make sure all files are uploaded to the correct directory on the server
- Then make sure you are browsing to the right path to the install.php file.
and here are the answers to the steps above:
- I have checked that the db user has all privileges and it does;
- The correct info is in wp-config.php, the info being:
/ The name of the database for WordPress */ define('DB_NAME', 'wordpress'); (correct) / MySQL database username / define('DB_USER', 'root'); (correct) /** MySQL database password / define('DB_PASSWORD', 'yourpasswordhere'); (don't have one) /* MySQL hostname / define('DB_HOST', 'localhost'); (correct)
- Then make sure all files are uploaded to the correct directory on the server. They are all sitting on C:\xampplite\htdocs\wordpress. So I believe that this is correct. I have everything situated on my computer until I have a test site up and running.
- Then make sure you are browsing to the right path to the install.php file. Well, I think I am. The path to install.php is here: C:\xampplite\htdocs\wordpress\wp-admin\install.php and here through localhost: http://localhost/wordpress/wp-admin/install.php, but this is where the Wordpress error shows up saying that "Error establishing a database connection".
Question: where can I test that that database base is running correctly through the phpadmin? I have clicked on the xampplite control panel and it says that it is running there.
Perhaps it isn't the database, perhaps it's something else but I have no idea how to troubleshoot this.
see screenshots: http://www.screencast.com/users/Feliciaf/folders/Wordpress
define('DB_PASSWORD', 'yourpasswordhere') passes "yourpasswordhere" as the password.
If the password is blank, try just using
Also, you may want to consider setting up a non-root user. Just a thought.
or just add a password ? it's the least you should ever do! even with wordpress on a local system
Thanks so much for the above answers. Setting the password to nil was the answer. Why I didn't see that I have no idea but now I know! Thanks