본문 바로가기
Server | Network

MySQL 비밀번호 복구

by 두루물 2010. 11. 11.
/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql> use mysql;
mysql> update user set password=PASSWORD("새 비밀번호") where User='root';
mysql> flush privileges;
mysql> quit
killall mysqld_safe
/etc/init.d/mysql restart