Mysql修改密码的方式
如果忘记密码--skip-grant-tables
1、alter user
alter user test@'localhost' identified by 'xxxx!';
2、grant
show grants for test@'localhost'; GRANT USAGE ON *.* TO 'test'@'localhost' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxx';
GRANT USAGE ON *.* TO 'test'@'localhost' IDENTIFIED BY 'xxxxxxxxxxxxx';
3、set password
set password for test@'localhost'=password('xxx')4、update mysql.user
mysql> UPDATE mysql.user SET Password = PASSWORD('newpass') WHERE user = 'test' and host='localhost';
mysql> FLUSH PRIVILEGES;5、mysqladmin
mysqladmin -u test password "newpass" #第一次设置 mysqladmin -u test password oldpass "newpass" #如果root已经设置过密码，采用如下方法
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
