1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Plesk restore doesn't work on new server

Discussion in 'Plesk for Windows - 8.x and Older' started by Toepes, Sep 23, 2006.

  1. Toepes

    Toepes Guest

    Server is Windows 2003, with plesk 7.6.1 installed. MSSQL and MYSQL

    As this server must be replaced with a new one i took a backup, downloaded it an try to install it on the new server. Also an windows 2003 server, plesk 7.6.1 MSSQL and MYSQL

    When i do the restore without any domain, everything works fine, i can change the passwords for MSSQL and MYSQL admin.

    Now i restore a domain with no database, still everything works fine.. Problem starts when i try to restore a domain with one ore more databases. I get the error that the databases cannot be restored because the password is not correct.
    I logged in as administrator, and i am 100% sure that the passwords for SA and ADMIN are the same

    After restoring a domain with a database, i notice in plesk that it cannot connect to MYSQL as the password is wrong.

    "Failed to connect to database access denied for user admin@localhost using password Yes

    I really need some help as the server must be brought back to the datacenter.
  2. chasovshic

    chasovshic Guest

    This problem occurs when Plesk connection to MySQL server, which is used for clients’ databases storing, has gotten misconfigured. To configure it back you need perform the following steps:

    1. Edit MySQL configuration file my.ini located within %plesk_dir%databases\mysql\data.
    2. Add parameter skip-grant-tables into the [MySQLD] section.
    3. Restart SQL Server.
    4. Log into MySQL.

    %plesk_dir%\mysql\bin\mysql.exe mysql
    5. Execute the following query:

    mysql> update user set password=password('current_password') where user='admin';
    6. Remove skip-grant-tables from within the [MySQLD] section within

    7. Restart SQL Server.

    Where `current_password` is the password for admin in client’s MySQL which is stored in Plesk. It is used by Plesk to control client’s MySQL server. If you do know what is the current password you can fetch it from Plesk database using this query:

    %plesk_dir%\mysql\bin\mysql -uadmin -p`pleskadmin_password` -P8306 psa
    mysql> select val from misc where param=’mysql_admin_passwd’;