i-MSCP Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

======How to change i-MSCP database SQL user password?======

=====If you know the old password=====

**1.** Set a new password to the existent SQL user
<code>
 # mysql -u root -p
 > UPDATE mysql.user SET Password=PASSWORD('cleartext password') WHERE User='root' AND Host='localhost';
 > FLUSH PRIVILEGES;
 > quit;
</code>

**Note:** Here, assumption is made that the i-MSCP SQL user is the SQL root user (default). Another way is to run the **mysql_secure_installation** script as provided with the MySQL server.

**2.** Inform i-MSCP about new password
<code>
 # perl /var/www/imscp/engine/setup/imscp-setup
</code>

Then, you will be asked again about i-MSCP SQL username and password.

=====If you do not know the old password=====

**1.** Set a new password to the existent SQL user
<code>
 # /etc/init.d/mysql stop
 # /usr/bin/mysqld_safe --skip-grant-tables &
 # mysql -u root
 > UPDATE mysql.user SET Password=PASSWORD('PASSWORD') WHERE User='root' AND Host='localhost';
 > FLUSH PRIVILEGES;
 > quit;
 # /etc/init.d/mysql start
</code>

**2.** Inform i-MSCP about new password
<code>
 # perl /var/www/imscp/engine/setup/imscp-setup
</code>

Then, you will be asked again about i-MSCP SQL username and password.

i-MSCP Documentation

User Tools

Site Tools

Page Tools