unable to log in Mywebsql getting error "Database connection failed to the server"

soumyabiswas250498 · 24. November 2018

Unable to log in Mywebsql with any user id password. getting error "Database connection failed to the server". This problem only exists on webgui. Works like charm on ssh. Luckily I found this thread but I could not locate ‘config/auth.php’. Consider i am newbie. Please help. using omv on raspberry pi 3

Odissine · 23. Dezember 2018

Hello, I've got the same issue ... I tried to modify root password manually via SSH ... password has been changes successfully for mysql db but still not works in GUI ... same error as soumy !

Any update ?

guzzisti · 23. Dezember 2018

Hi, maybe the permissions or the config of the mysql server are messed up.

First step is to have a look at the file /etc/my.cnf. Check if there`s an entry "bind-address" in the section [mysqld]. It should be set to 0.0.0.0.

Second step:
Log in through ssh as root and run the following command in the mysql-prompt. Post the output in this thread:

SQL

SELECT user,host,plugin FROM mysql.user;

Jetzt mitmachen!