修改时遇到问题记录一下:
登录数据库:mysql -hlocalhost -u root -p password
修改密码:update user set authentication_string=password('newpassword') where user='root';
注:5.7之后user表里password字段改为authentication_string
停止net stop MySQL57(服务名称)
启动net start MySQL57
修改时遇到问题记录一下:
登录数据库:mysql -hlocalhost -u root -p password
修改密码:update user set authentication_string=password('newpassword') where user='root';
注:5.7之后user表里password字段改为authentication_string
停止net stop MySQL57(服务名称)
启动net start MySQL57