WordPress.org

1. joshlee18
   Member
   Posted 4 months ago #

   I have done everything it has said to troubleshoot my issue. I have no idea on how to fix this and could really use some help. Thanks in advance... Here is the message it gave me on the http://www.triedandtruetutoring.com/wp-admin page. The site has been up and working previous to this. If my topic is not in the right section please tell me where to place it.

   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 mysql.triedandtruetutoring.com. 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.

2. jonradio
   Member
   Posted 4 months ago #

   OK, I know you are using DreamHost. I also know from the message that the problem has nothing to do with the CONTENT of the database. The database could be empty and you would not get this message if everything else was right.

   Go to this link: https://panel.dreamhost.com/index.cgi?tree=goodies.mysql

   And match the Database Host, Database Name and Database User shown on that page with the ones you have in http://www.triedandtruetutoring.com/wp-config.php Check here for details on the file: http://codex.wordpress.org/Editing_wp-config.php

   Make sure that the Database User is shown on the DreamHost page BESIDE the Database Name.

   If they all match, then click on the Database User link on the DreamHost page. Be sure all the boxes are checked and that Allowable Hosts says "%.dreamhost.com".

   Now type in the password listed in wp-config.php into the two password fields and click on the Modify button at the bottom.

   Try http://www.triedandtruetutoring.com/wp-admin again. If it still doesn't work, I'm stumped.

3. joshlee18
   Member
   Posted 4 months ago #

   First off thank you for replying so quickly. I tried doing that before as I thought that was the issue but it still is not working. I really have no idea how this happened. Thanks for attempting to help. Any suggestion on who I can contact for further support?

4. jonradio
   Member
   Posted 4 months ago #

   The top of that DreamHost Panel page has this to say:

   MySQL Database Management
   Be sure to review the MySQL documentation in our wiki!
   To access a database from the command line, use:

   mysql -u username -ppassword -h hostname databasename

   (Note: there's no space between the -p and the password!)
   You can create as many MySQL users and databases as you'd like.

   I would suggest connecting via SSH and doing just that command. If you haven't used SSH on DreamHost, you're going to need to sometime, so now is as good a time as any to start. I'm a fan of Poderosa as an SSH client, if you are looking for one; it is Open Source.

   In my own experience, however, I just keep staring at things, "checking them twice", as I posted in my previous post, and usually something odd pops up like a zero that is really the letter O.

   I would also try backing up the database, deleting it, recreating it, assigning the database user id with full rights, and testing again, to see if you get past that error, to one that tells you the database is empty, before restoring the database.

   I'd also be contacting WordPress support in writing at https://panel.dreamhost.com/index.cgi?tree=support.msg especially if the mysql -u username -ppassword -h hostname databasename command did not work.

Reply

You must log in to post.