Wordpress Installation "Error establishing a database connection".

June 18, 2015 8.5k views
Ubuntu PHP WordPress

Hello I have had wordpress installed and working perfectly but today I found an error on my site saying “Error establishing a database connection” and on the wp-admin page I see this: http://i.imgur.com/Ktaurvh.png

I have had a look at this article: http://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/ but I don’t remember mysql database password…

I can’t even remember what I named it tho looking in my wp-config.php file I see:

define(‘DBNAME’, 'wordpress’);
define('DB
USER’, 'wordpress’);

I used a one click install and i can not remember if i set this or if its default.

Is myphpadmin down? can i check without the password? can I find the password.

I have root access. Droplet stats 512MB Ram - 20GB - SSD Disk - New York 3 - Ubuntu WordPress on 14.04

Looking in my /var/log/syslog this is all that’s there but it does seem to be today’s date.

Jun 18 06:39:01 ***sitename-censored*** CRON[13943]: (root) CMD (  [ -x /usr/lib/php5/maxlifetime ] && [ -x /usr/lib/php5/sessionclean ] && [ -d /var/lib/php5 ] && /usr/lib/php5/sessionclean /var/lib/php5 $(/usr/lib/php5/maxlifetime))
1 comment
  • If you have root access, I would start by connecting to SSH and restart the server to make sure that any service gets restarted.

    If you think that the info on your wp-config.php file is not correct something most of happen that change it. You can find out your DB name by SSH with the following code set

    mysql -u root -ppassword
    
    SHOW DATABASES
    

    To find out the users you can run

    select * from mysql.user;
    

    Lastly to change a password for a user you can run

    SET PASSWORD FOR 'user-name-here'@'localhost' = PASSWORD('new-password-here');
    

    hope this helps you figure out. Let us know if you have nay other questions

    Good Luck!!

1 Answer

This question was answered by @aguilar1181:

If you have root access, I would start by connecting to SSH and restart the server to make sure that any service gets restarted.

If you think that the info on your wp-config.php file is not correct something most of happen that change it. You can find out your DB name by SSH with the following code set

mysql -u root -ppassword

SHOW DATABASES

To find out the users you can run

select * from mysql.user;

Lastly to change a password for a user you can run

SET PASSWORD FOR 'user-name-here'@'localhost' = PASSWORD('new-password-here');

hope this helps you figure out. Let us know if you have nay other questions

Good Luck!!

View the original comment

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!