This is an old revision of the document!
1. Set a new password to the existent SQL user
# mysql -u root -p > UPDATE mysql.user SET Password=PASSWORD('cleartext password') WHERE User='root' AND Host='localhost'; > FLUSH PRIVILEGES; > quit;
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
# perl /var/www/imscp/engine/setup/imscp-setup
Then, you will be asked again about i-MSCP SQL username and password.
1. Set a new password to the existent SQL user
# /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
2. Inform i-MSCP about new password
# perl /var/www/imscp/engine/setup/imscp-setup
Then, you will be asked again about i-MSCP SQL username and password.