root비번을 잊어버렸을때..
programming/mysql 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
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
'programming > mysql' 카테고리의 다른 글
mysql table size 변경 (0) | 2012.04.18 |
---|---|
시작/종료 (0) | 2012.04.10 |
mysql원격접근 (0) | 2012.01.27 |