以備不時之需, 先把預想到會忘記的事情做個 note XD

1. stop mysqld
2. safe_mysql --skip-grant-table&
3. mysql mysql
mysql> UPDATE user SET password = password('newpassword') WHERE user = 'root';
mysql> FLUSH PRIVILEGES;
4. mysqladmin -uroot -p shutdown
5. restart mysqld

ieon 發表在 痞客邦 PIXNET 留言(0) 人氣()