Index

• Stop the mysqld daemon process.
• Start the mysqld daemon process with the –skip-grant-tables option.

/etc/mysql/my.cnf
....
[mysqld]
skip-grant-tables
....

• Start the mysql client with the -u root option.
• Execute the UPDATE mysql.user SET Password=PASSWORD(’password’) WHERE User=’root’;
• Execute the FLUSH PRIVILEGES; command.