1045 Access denied for user ‘root’@‘localhost’ (using password: YES)
grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
flush privileges;
SELECT * from mysql.user\G;
找到root用户的authentication_string这项,并把它的值记下来,然后继续执行以下命令
update mysql.user set authentication_string = ‘*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9’ where user = ‘root’;here user = ‘root’;
flush privileges;
mysql远程连接访问不了的问题记录i(1045 Access denied for user ‘root‘@‘localhost‘ (using password: YES)
最新推荐文章于 2022-07-13 09:03:05 发布