论坛 › mysql › mysql access denied for root ... mysqld –skip-grant-tables 命令失效 .

谢楷锋 发表于 2024-2-26 10:32:19

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 

mysql -uroot -p 
flush privileges; 
ALTER USER 'root'@'%' IDENTIFIED BY '123456'; 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; 
ALTER USER 'root'@'localhost' IDENTIFIED BY 'mysql'; 
flush privileges;
quit 


来源:https://www.cnblogs.com/jiayouba/p/18033166
免责声明：由于采集信息均来自互联网，如果侵犯了您的权益，请联系我们【E-Mail:cb@itdo.tech】 我们会及时删除侵权内容，谢谢合作！

查看完整版本: mysql access denied for root ... mysqld –skip-grant-tables 命令失效 .