mysql access denied for root ... mysqld –skip-grant-tables 命令失效 .
|
- mysqld --skip-grant-tables
复制代码 - use mysql;
- update user set password=password('123456') where user='root';
- flush privileges;
- quit
复制代码
- mysqld --defaults-file='C:\ProgramData\MySQL\MySQL Server 8.0\my.ini' --console --skip-grant-tables --shared-memory
复制代码
- ALTER USER 'root'@'%' IDENTIFIED BY '123456';
复制代码 - ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
复制代码 - ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql';
复制代码
来源:https://www.cnblogs.com/jiayouba/p/18033166
免责声明:由于采集信息均来自互联网,如果侵犯了您的权益,请联系我们【E-Mail:cb@itdo.tech】 我们会及时删除侵权内容,谢谢合作! |
|
|
|
发表于 2024-2-26 10:32:19
举报
回复
分享
|
|
|
|