본문 바로가기
MySQL

mysql root 패스워드 분실시

by GoodDev 2018. 7. 19.

/sbin/service mysqld stop

/usr/bin/mysqld_safe --skip-grant &

$ /usr/bin/mysql -uroot mysql

mysql> update user set password=password('') where user='root';

mysql> flush privileges;

mysql> quit

/sbin/service mysqld stop

$ /sbin/service mysqld start

댓글