Test connection to the database server has failed because of network problems: Failed to connect to database: Access denied for user 'admin'@'localho

Error: Test connection to the database server has failed because of network problems:

Hello,

Most of the time while configuring MY SQL server in windows plesk control panel we can get the following error.

Error: Test connection to the database server has failed because of network problems:

Failed to connect to database: Access denied for user 'admin'@'localhost' (using password: YES)

Fix :: Login the server via RDP >>> open my.ini with "%plesk_dir%databases\mysql\data." >>> add the parameter skip-grant-tables=1

Restart MYSQL service.

Then connect the mysql database with following command

"%plesk_dir%\mysql\bin\mysql.exe" mysql

Execute following query

mysql> update user set password=password('current_password') where user='admin';


Remove skip-grant-tables=1 from %plesk_dir%\databases\mysql\data\my.ini

restart MYSQL service.

And then no error will come while configuring MYSQL database in plesk