Translate

Tuesday, September 21, 2010

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

2 comments:


  1. Awesome! Its actually remarkable piece of writing, I have got much clear idea regarding from this piece of writing. sign in hotmail

    ReplyDelete
  2. Depending on your needs for file storage space, you may need more or less. Generally the more disk space offered, the better.minecraft server hosting

    ReplyDelete

About Me

My photo
Greetings Friend! I am Linux scholar, trying to learn as much I can and share it with you. I am in mid of my Professional Career. Doing Good. :)

Followers

Blog Archive