Announcement

Collapse
No announcement yet.

How to reset the MySQL administrator's password on Plesk server

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to reset the MySQL administrator's password on Plesk server

    If you forget the Mysql server password, you can reset it, using the below steps:

    1. Stop the MySQL server (but not "Plesk SQL Server") from running on port 3306 using the Plesk Services Monitor tray utility or from services.

    2. Edit the MySQL configuration file, %plesk_dir%\Databases\MySQL\Data\my.ini (or your installation path), and add the line skip-grant-tables to the [mysqld] section.

    3. Start the MySQL server.

    4. Log into MySQL without the password:
    "%plesk_dir%\Databases\MySQL51\bin\mysql.exe"

    To change the password for the MySQL administrator run the below 2 commands in the MySQL console:

    UPDATE mysql.user SET Password = password('newpassword') WHERE User = 'admin';
    flush privileges;


    5. Remove skip-grant-tables from the MySQL configuration file and restart the service.

    6. Log into the Plesk interface, go to the database server management settings (Tools & Settings > Database Servers), and change the password for the corresponding database server to the one set in Step 4, Plesk will re-establish the connection to the server.

    Regards,
    Yusuf M
    Last edited by Yusuf; 07-12-2014, 09:05.

  • #2
    Re: How to reset the MySQL administrator's password on Plesk server

    Thankyou for step by step info, basic and vital

    Comment

    Working...
    X