Allows you to search a variety of questions and answers
Such problem occurs when password for *admin* in Plesk does not match the one set in MySQL.
You can fix it yourself using the following instructions.
First of all, you must know you current Plesk password. If you have forgotten it for some reason then the password can be taken using %plesk_bin%\plesksrvclient.exe -get
Then, you should set it up within Plesk MySQL. To do it, please, follow the steps:
1. Edit MySQL configuration file my.ini located within %plesk_dir%\mysql\data\.
2. Add parameter skip_grant_tables=1 into the [PleskSQLServer] section.
3. Restart service Plesk SQL Server.
4. Log into Plesk MySQL.
%plesk_dir%\mysql\bin\mysql.exe -P8306 mysql
5. Execute the following query:
mysql> update mysql.user set password=password('current_password') where user='admin';
6. Remove skip_grant_tables=1 from within the [PleskSQLServer] section within %plesk_dir%\mysql\data\my.ini
7. Restart service Plesk SQL Server.
A new password has to be applied.
Note: my.ini for MySQL on Plesk 7.0 is located in %SystemRoot% (usually it points to c:\windows\)
Dedicated Semi-Managed Server Review I've been using AYKSolutions for about 2 years now and their support and servers have been great. They assisted me with the transition of all my websites and databases from my old server onto their system with no problem. If I ever need them for support or a change they respond fast and always keep me up to date with the status of my support ticket. I highly recommend using this company especially if you're looking for someone to assist with server management. Best of all their cost is great!
I have been using AYK for about 2 years now and they are always on top of any issues I have. They have gone over and beyond helping me with any problems that come up with the server and they have never said "no" to any of my requests. I would definitely recommend them to anyone looking for a reliable server company.
Very courteous, professional, and willing to help. They truly care about client based relationships and satisfaction. I will definitely refer more clients their way, and highly recommend Ayksolutions to anyone seeking truly the best.