Changing MySQL Root Password - H-Sphere Sysadmin Guide

H-Sphere Sysadmin Guide

Changing MySQL Root Password

Related Docs:

• Restarting MySQL Server

This document explains how to change the root user password in MySQL access privilege database.

Login as root to the box with the MySQL server.
Stop MySQL server.
Open the mysql server startup script. This is the file you have just executed to stop MySQL server.
Find the line that contains teh safe_mysqld command and add --skip-grant-tables as its parameter.
Start MySQL server.
Login as the mysql user and connect to the mysql user/permission database:
# su -l mysql
# mysql -u root mysql
Run the following two queries:
mysql> UPDATE user SET Password=PASSWORD('newrootpassword') WHERE User='root';
mysql> FLUSH PRIVILEGES;
replacing newrootpassword with the new root password to the box with the MySQL server.
Exit mysql database by typing \q.
Exit mysql user console by typing exit
Stop MySQL server.
Open the mysql server startup script and remove the --skip-grant-tables parameter you added above.
Start MySQL server.

Related Docs:

• Restarting MySQL Server