Senin, 22 Agustus 2011

Reset Password MySQL

1. service mysqld stop

2. mysqld_safe --skip-grant-tables &

3. Masuk ke MySQl dengan username root tanpa password.
# mysql -u root

4. Reset Password
#use mysql
# UPDATE user SET password=PASSWORD('newpass') WHERE user='root';
#FLUSH PRIVILEGES;
# quit

5. Restart Service mysql
# /etc/init.d/mysqld restart

6. Testing:
# mysql -u root -p
Atau lewat browser phpmyadmin..

Tidak ada komentar:

Posting Komentar