computer:2:know

mysql - reset root password

 http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix

1. Stop mysqld and restart it with the --skip-grant-tables option. This enables anyone to connect without a password and with all privileges. Because this is insecure, you might want to use --skip-grant-tables in conjunction with --skip-networking to prevent remote clients from connecting. 

2. Connect to the mysqld server with this command:  mysql

3. mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')               WHERE User='root';

4. mysql> FLUSH PRIVILEGES;

Computer and IT knowledge - things to know

mysql - reset root password