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>