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!!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
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

Submit an Answer