Server | Network
MySQL 비밀번호 복구
두루물
2010. 11. 11. 16:26
/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
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