Friday, November 19, 2010

Reset Mysql Root Password, windows

start at command prompt

net stop mysql

mysqladmin --skip-grant-tables

mysql -u root


mysql> use mysql;
mysql> UPDATE user SET Password = PASSWORD ('isi_password_baru') WHERE User='root';
mysql> FLUSH PRIVILEGES; 
mysql> quit;

net start mysql

0 comments: