以備不時之需, 先把預想到會忘記的事情做個 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
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
全站熱搜
留言列表