Important instructions for the tutorial
This tutorial only applies to Linux distributions, which uses the MSQY-server.
The # implies by default that in most cases, a console-command has to be accomplished with root privileges.
The $ implies by default that this command can be accomplished with standard user-rights.
First, you have to stop the MySQL server and restart it in safe mode with the option to ignore the right tables.
# /etc/init.d/mysql stop
# mysqld_safe --skip-grant-tables
A shell program will open immediately, please do not close it.
Please open a second SSH2 connection or a second console. The MySQL server runs in safemode, this is required because it is in the first shell.
Please use the following commands to reset your password:
# mysql –u root
# update user set password=PASSWORD('newpassword') where user='root';
# flush privileges;
The password of the root-user has been changed already into your new password. In addition you can close the second console now.
How to terminate the Safemode:
Go back to your first console. You can terminate the safe mode from the MySQL server with the command CTRL + C.
Ater that please restart the MySQL server:
# /etc/init.d/mysql start
The reset is completed now and the root-user has the new password.