Related

Product App Platform: Run PHP apps without managing servers Product
PHP Re-loop a foreach loop to sort images according to size Question Question
Wordpress: You do not have sufficient permissions to access this page Question Question

Question

Wordpress Installation "Error establishing a database connection".

Posted June 18, 2015 9.8k views
UbuntuPHPWordPress

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('DBUSER’, '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))
Add a comment
ac130nz
By:
ac130nz
Add a comment
1 comment
  • aguilar1181 June 18, 2015
    Reply Report

    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
asb June 8, 2016

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

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help