平时没怎么用过 Mysql, 今天有个小程序需要用一下, 但是忘记怎么修改用户密码了, 网上搜索一下, 记录一下.
1 update user set authentication_string = password('root'), password_expired = 'N', password_last_changed = now() where user = 'root';
重启 MySQL 服务后生效.
来源: http://www.bubuko.com/infodetail-2588662.html