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

7 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
  3. I have been searching for a useful post like this on salesforce course details, it is highly helpful for me and I have a great experience with this Salesforce Training who are providing certification and job assistance. Salesforce training in Noida

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. Hence, you may need to remember of the amount increase in mortgage payments you would afford when the rates sky rocket. mortgage calculator It is essential for homeowners to understand that in the long run, all rates are variable. canada mortgage calculator

    ReplyDelete
  6. We sell original Herbal Products composed of Natural Herbs Clinic obtained from the world’s top botanic gardens under the cautious administration of experts who are working day and night to make the herbal products even better and to increase the range so that people suffering from certain ailments which do not have any identified care as yet can benefit from our formulas.

    ReplyDelete
  7. Thanks for the detailed article on this topic. I would like to see more such awesome articles from you. Also you can get the new and best features of GBWhatsapp which are coming in 2022- GBWhatsapp 2022 APK

    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