BLACK FRIDAY DEALS

Knowledge Base

Allows you to search a variety of questions and answers

Search

Search results

Plesk

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\)

See What Our Customers Say

Leave review
B

Bogdan C

iasi, Romania

This is my second time i m using your services, and the main reason i'm doing that, beside your pric...

Read full review
A

AnyMood.co

TX, United States

I've been a client of AYK Solutions for about six months now. They have provided the best overall ex...

Read full review
L

Luis

Thanks for the fast sollution, it was my fault since my original e-mail got somehow bugged and I did...

Read full review
K

kkodev

London, United Kingdom

After getting a dedicated server from AYK for almost 2 years, I couldn't be more happy. The prices...

Read full review
ARIN Cisco Supermicro cPanel Intel Microsoft