Mac系统下,mysql忘记密码怎么办?
- 在系统偏好 中,中止MYSQL服务.;
- cd/usr/local/mysql-…/bin
sudo ./mysqld_safe–skip-grant-tables - 登录MySQL;
mysql - 置空root用户的密码;
mysql>
update user set password=PASSWORD(‘RNNrnn123456’) where user=‘root’;
mysql> flush privileges;
mysql> quit - 重新启动MySQL服务,
- 添加密码mysql> mysqladmin -u root -p password 123 密码改为123