[SOLVED] LAMP - “Error establishing a database connection” on local installation of wordpress

byebyemrgates · 08-22-2019, 01:02 AM

Hi there! Can someone help diagnose “Error establishing a database connection” on local installation of Wordpress on LAMP.
I followed this tutorial: https://www.digitalocean.com/communi...n-ubuntu-16-04
Checked database password and name in wp-config.php
If it is clue – this address 127.0.0.1:3306 gives this message in browser:

Code:

[���
5.7.27-0ubuntu0.18.04.1�3���BHL�ÿ÷�ÿ����������%:3{Y@jE�mysql_native_password���ÿ„Got packets out of order

I got 3306 from this:

Code:

~$ netstat -tln
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State      
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:139             0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN     
tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN     
tcp        0      0 0.0.0.0:445             0.0.0.0:*               LISTEN     
tcp6       0      0 :::139                  :::*                    LISTEN     
tcp6       0      0 :::80                   :::*                    LISTEN     
tcp6       0      0 ::1:631                 :::*                    LISTEN     
tcp6       0      0 :::445                  :::*                    LISTEN

bathory · 08-22-2019, 03:14 AM

Hi,

Can you connect to the database you created for wordpress from CLI:

Code:

mysql -u wordpress-user -pwordpress-password wordpress-database

byebyemrgates · 08-22-2019, 03:56 AM

Sorry, I found the solution myself after hours (luckily I had spare hours in sick leave...)
For others who may have this issue:
installed phpmyadmin but could not get access to it, so found this post:
https://askubuntu.com/questions/6687...on-this-server

used these commands it mentions:

Code:

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf

sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin

sudo service apache2 restart

after that, could get wp-admin page, but it said that database does not exist.
created database again - and it worked...

Perhaps someone would like to explain what happened there?..

bathory · 08-22-2019, 04:38 AM

Quote:

after that, could get wp-admin page, but it said that database does not exist.
created database again - and it worked...

Perhaps someone would like to explain what happened there?..

Perhaps you made a typo when you first created the database so WP could not connect to it. And maybe that's why you were able to created it again, I guess with the same name!
Now you've installed phpmyadmin, you can use it to see the existing databases and verify if that was the case.

Regards