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

BoxTrapper: Protect your inbox from spam.

Mailing Lists: Send messages to a large group of people.

Auto Responders: Send a message back automatically to anyone who sends an email to a certain account.

Forwarders: Send a copy of all mail from one email address to another.

Email Accounts: Manage the email accounts associated with your domain(s).

Edit Preview Images: Add a preview image to a branding style.

Edit UI: Modify the containers that hold icons and messages on the main page of the cPanel interface.

Edit Header/Footer: Change the header and footer images of the cPanel interface.

Edit Icons: Change the icons that appear on the main page of the cPanel interface.

Edit Logos: Resize and drag your own logo where you want it to appear.

Quick Image Edit: The basics on editing an image.

Getting Started: Getting Started on customizing your cPanel.

Branding (for root user): Learn branding specifically for a root user.

Web Disk: Easily drag and drop files to your hosting account.

Ftp Accounts: Access your web site's files through a protocol called FTP.

Backups

Download (to your computer) a zipped copy of either your entire site (your home directory, databases, email forwarders configuration, email filters configuration) or one of the previously mentioned parts of your site.

File Manager: Quickly manager all of your files with the new File Manager.

Quickly manager all of your files with the new File Manager.

SSH/Shell Access: Manage your SSH keys to allow automation when logging in via SSH.

Manage your SSH keys to allow automation when logging in via SSH.

Site Software: Blogs, Bulletin Boards, CMS, Chat, Ecommerce, and more!

Blogs, Bulletin Boards, CMS, Chat, Ecommerce, and more!

IP Deny Manager: Block a range of IP addresses to prevent them from accessing your site.

Block a range of IP addresses to prevent them from accessing your site.

Hotlink Protection: Prevents other websites from directly linking to files on your website.

Prevents other websites from directly linking to files on your website.

GnuPG Keys

Generate or import GnuPG Keys to encrypt messages using a "public key" that can only be decrypted by a "private key", which is retained by the intended recipient of the message.

My SQL: A guide to creating and modifying MySQL databases in cPanel.

Subdomains: Learn all about creating and managing subdomains.

MySQL Wizard: Create and manage MySQL databases with this step by step wizard.

Shortcuts: Easily access your cPanel by adding cPanel shortcuts to your desktop or browser's bookmarks toolbar.

Updating Your Contact Information: Change your contact information as well as preferences.

Change Style: A quick guide on changing the look and feel of cPanel to fit your personal style.

Parked Domains: Learn about creating and managing parked domains.

Addon Domains Learn about creating and managing addon domains.

Redirects: Learn how to make a specific web page redirect to another page and display the contents of that page with redirects

Kloxo Panel Demo

If you want Kloxo Panel Demo then you can use lxlab for the same. Cick on following link to get Kloxo panel Demo


http://demo.kloxo.com:7778/login/

you will find following information there

Login as Customer/Domain Owner (customer)
Login as Mail Account (postmaster@example.com)
You can also Visit kloxo forums.
If you need more information you can visit lxlabs.com
Generally this will not ask for any credential.

Change Password: Change the main password for your account.

Password Protect Directories

Learn how to limit access to a certain part of your site by requiring a user name and password to access a folder or folders from the web.