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.
    10x

    OpEn YouR mINd , OpeN YouR SourcE cOdE

  • Hello ;


    How you changed the SQL user root password exactly?


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



    Thanks you for using i-MSCP

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • 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 1.0.3.0

    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. http://wiki.i-mscp.net/doku.ph…o:reset_database_password


    Thank you for using i-MSCP.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    Edited once, last by Nuxwin ().