MySQL Reset Password

  • Hello,
    Write you about my hosting panel.
    Today, I change my MySQL password. But there is another problem
    Warning: The Exception Writer `iMSCP_Exception_Writer_Browser` was unable to write the following message: `Unable to establish the connection to the database. SQL returned: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) - at line: 371 in file: /var/www/imscp/gui/library/iMSCP/Initializer.php` Reason: Unable to find the box.tpl template file - at line: 532 in file: /var/www/imscp/gui/library/iMSCP/pTemplate.php in /var/www/imscp/gui/library/iMSCP/Exception/Handler.php on line 319.
    Will you help me to fix this.

    OpEn YouR mINd , OpeN YouR SourcE cOdE

  • Hello ;

    How you changed the SQL user root password exactly?

    What distro your are using?
    What i-MSCP version you are using?

    Thanks you for using i-MSCP


  • Step # 1: Stop the MySQL server process.
    Step # 2: Start the MySQL (mysqld) server/daemon process with the --skip-grant-tables option so that it will not prompt for password.
    Step # 3: Connect to mysql server as the root user.
    Step # 4: Setup new mysql root account password i.e. reset mysql password.
    Step # 5: Exit and restart the MySQL server.

    Debian 2.6.32-5-openvz-686.
    i-MSCP Version is a

    OpEn YouR mINd , OpeN YouR SourcE cOdE

  • Re ;

    Next time, read our documentation. :P

    You must do the steps as stated into the "Recover i-mscp database user" stanza.…o:reset_database_password

    Thank you for using i-MSCP.


    Edited once, last by Nuxwin ().