programming/mysql

root비번을 잊어버렸을때..

applicationlayer 2011. 10. 9. 12:31
service mysql stop 

wait until MySQL shuts down. Then run 

mysqld_safe --skip-grant-tables & 

then you will be able to login as root with no password. 

mysql -uroot mysql 

In MySQL command line prompt issue the following command: 

UPDATE user SET password=PASSWORD("abcd") WHERE user="root"; 
FLUSH PRIVILEGES; 
EXIT 

/etc/init.d/mysqld restart 

At this time your root password is reset to "abcd" and MySQL will now 
know the privileges and you'll be able to login with your new password: 

mysql -uroot -p mysq


http://translate.google.co.kr/translate?hl=ko&sl=en&tl=ko&u=http%3A%2F%2Fforums.vpslink.com%2Fcentos%2F1264-mysql-root-default-password.html&anno=2