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
Subscribe to:
Post Comments (Atom)
About Me
- Himanshu
- 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. :)
ReplyDeleteAwesome! Its actually remarkable piece of writing, I have got much clear idea regarding from this piece of writing. sign in hotmail
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
ReplyDeleteI 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
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHence, 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