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 

'programming > mysql' 카테고리의 다른 글

mysql table size 변경  (0) 2012.04.18
시작/종료  (0) 2012.04.10
mysql원격접근  (0) 2012.01.27
Posted by applicationlayer
: