ac130nz
By:
ac130nz

Wordpress Installation "Error establishing a database connection".

June 18, 2015 4.4k views
WordPress PHP Ubuntu

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.