Hi

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

3 answers

3
points
This was chosen as the best answer

define('DB_PASSWORD', 'yourpasswordhere') passes "yourpasswordhere" as the password.

If the password is blank, try just using

define('DB_PASSWORD', '')

Also, you may want to consider setting up a non-root user. Just a thought.

Answered over 7 years ago by Jeremy Orion
Jakob 17
2
points

or just add a password ? it's the least you should ever do! even with wordpress on a local system

Answered over 7 years ago by Jakob
0
points

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

Answered over 7 years ago by Felicia