Im unable to login to phpmyadmin

[atozhacks]

Im using server with centOS 7.5 and VESTA CP,I restored backup of wordpress and everything's fine but suddenly all the database's are going down,Due to which my site,android app are going down,I've to restart the server from VESTA PANEL to get them back,Someone please help me..
Here is the error im getting for no reason and it gets fixed after restarting the server :

Cannot login to MYSQL Server
mysqli_real_connect():(HY000/2002): Connecting refused
configuration for controluser defined in your configuration failed.
mysqli_real_connect():(HY000/2002): Connecting refused

Please help me..

[skamasle]

Hi

A supose you solve your problem, but in any orther issue, please provide logs.

[caustino]

I solved it in this simple way
***** restore user root mysql *****
mysql -u root -p mysql
MariaDB [mysql]> update user set plugin='' where user='root';
MariaDB [mysql]> flush privileges;
MariaDB [mysql]> exit
***********************************

to disable user root again ....
update user set plugin='unix_socket' where user='root';

viewtopic.php?t=14658