MyWebSQL : Unable to connect

Duff · Oct 6th 2017

Hi,

Since i updated OMV to 4.0 (4.0.5-1 exactly), i can't connect to mysql with mywebsql ("database connection failed to the server"), but in shell with "mysql -u root -p", it's working.

So i've tried to uninstall all the Mysql components :

Quote

dpkg -l | grep -i mysql
mkdir -p /var/lib/mywebsql
apt-get remove --purge mysql\*
apt-get clean
rm -R /var/lib/mysql
rm -R /etc/mysql
dpkg -l | grep -i mysql

Display More

And then reinstall the plugin with the OMV WebGUI, but no result.

I think that the "Reset password" in the OMV webgui not work because in "/etc/mysql/debian.cnf" the root password is always empty.

My config is default : 127.0.0.1 / 3306.

Any idea ?

ryecoaaron · Oct 6th 2017

I will have to look at this. The switch to php7 may be causing issues. We may also be missing something that happens in the upgrade process.

Duff · Oct 6th 2017

Thank you for your work and your time.

For the moment MySQL is just a my DB for nextcloud. So i worked with shell, just create a database for nextcloud and grant permissions to root with a password :

Quote

CREATE DATABASE nextcloud;

GRANT ALL PRIVILEGES ON nextcloud.* TO 'root'@'localhost' IDENTIFIED BY '***password***';

And it works.

Duff · Oct 9th 2017

MyWebSQL is working fine with the new MySQL 4.1.1 Plugin

Thanks for this fast job !

BUFU1610 · Aug 15th 2018

Interestingly, I just had the same problem with 4.1.1, but after creating the db for nc and granting root permissions as described above, I can access it via the webfront again.

pwepwe973 · Nov 21st 2018

Hello community,
Excuse my bad english.I am French speaking.

I have encountered the same problem for 4 days. I have tried all the previous procedures, reinstall the system.I am under omv 4, in ssh with "mysql -u root -p" I also connect but via MyWebSql impossible "The database connection failed on the server"have you found a solution?

Odissine · Dec 23rd 2018

Hello pwepwe, I'v got the same issue (french too). In SSH I can connect into my SQL with root password, but in OMV (via MyWebSQL GUI it doesn't works ...)

Need help to configure and access GUI for installing new Database :)T
Thanks for your help

cleimarcia · Dec 30th 2018

I have the same problem after upgrading from OMV3.X to 4.1.16. Meanwhile I could solve the problem by creating a user "root2"

https://wiki.ubuntuusers.de/MySQL/

Login als root

Code

sudo mysql -u root -p

Create a new user, e.g. "root2" with the password "secret":

Code

create user 'root2'@'localhost' identified by 'secret';

Free all databases for the user

Code

grant all on *.* to 'root2'@'localhost' identified by 'secret' with grant option;

and finally update the database

Code

flush privileges;

and log out

Code

quit

Now I can log in successfully via the plugin Mysql in OMV (user-ID "root2" password "secret")

under tools I delete the root@localhost account.

then I create a new "root" account with password

now only unsubscribe

login via root should be possible

good luck trying it out

Afterlite · Jan 5th 2019

Thank you @cleimarcia, i've had problems all day and the solution was so simple

MyWebSQL : Unable to connect

Participate now!

Tags