Cara reset password MySQL

if you really forget what your mysql root password, this is just 6 easy steps to reset the password of your mysql.

1. Stop MySQL service

#/etc/init.d/msql  stop

2. Start MySQL safe mode

#mysqld_safe --skip-grant-tables  &

Output :

[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started

Press anykey

3. Connect to mysql server using mysql client:

#mysql -u root

Now you are not asked to enter a password

Output :

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>



4.Setup new MySQL root user password

mysql>use mysql;
mysql>update user set password=PASSWORD("Your_New_Password") where User='root';
mysql>flush privileges;
mysql>quit

5. Stop MySQL Server

#/etc/init.d/mysql stop

Output:

Stopping MySQL database server: mysqld
STOPPING server from pid file /var/run/mysqld/mysqld.pid
mysqld_safe[6186]: ended
[1]+  Done                    mysqld_safe --skip-grant-tables

6. Start MySQL server and test it

#/etc/init.d/mysql start
#mysql -u root -p