【mysql】mysql8如何更改root的密码并开启远程访问
1 首先进入到数据库
mysql -uroot -p
use mysql;
2 然后执行以下命令
GRANT ALL ON *.* TO 'root'@'%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;
mysql -uroot -p
use mysql;
GRANT ALL ON *.* TO 'root'@'%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
flush privileges;