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

5 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
    Replies
    1. Great Article
      Cyber Security Projects

      projects for cse

      Networking Security Projects

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  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

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