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
This blog is dedicated to all the scholar of web hosting. You will get all solution of your web hosting issue. If you have any query regarding web hosting then you can mail me whatishosting.com[at]gmail.com
Translate
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. :)
Followers
Blog Archive
-
▼
2010
(52)
-
▼
September
(35)
- Test connection to the database server has failed ...
- BoxTrapper: Protect your inbox from spam.
- Mailing Lists: Send messages to a large group of ...
- Auto Responders: Send a message back automaticall...
- Forwarders: Send a copy of all mail from one emai...
- Email Accounts: Manage the email accounts associa...
- Edit Preview Images: Add a preview image to a bra...
- Edit UI: Modify the containers that hold icons an...
- Edit Header/Footer: Change the header and footer ...
- Edit Icons: Change the icons that appear on the m...
- Edit Logos: Resize and drag your own logo where y...
- Quick Image Edit: The basics on editing an image.
- Getting Started: Getting Started on customizing y...
- Branding (for root user): Learn branding specific...
- Web Disk: Easily drag and drop files to your host...
- Ftp Accounts: Access your web site's files throug...
- Backups
- File Manager: Quickly manager all of your files w...
- SSH/Shell Access: Manage your SSH keys to allow a...
- Site Software: Blogs, Bulletin Boards, CMS, Chat,...
- IP Deny Manager: Block a range of IP addresses to...
- Hotlink Protection: Prevents other websites from ...
- GnuPG Keys
- My SQL: A guide to creating and modifying MySQL d...
- Subdomains: Learn all about creating and managing...
- MySQL Wizard: Create and manage MySQL databases w...
- Shortcuts: Easily access your cPanel by adding cP...
- Updating Your Contact Information: Change your co...
- Change Style: A quick guide on changing the look ...
- Parked Domains: Learn about creating and managing...
- Addon Domains Learn about creating and managing a...
- Redirects: Learn how to make a specific web page ...
- Kloxo Panel Demo
- Change Password: Change the main password for you...
- Password Protect Directories
-
▼
September
(35)
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