cmd进入bin目录,登录mysql
alter user root@localhost identified by ‘password’; tyzZ001!
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
5.授权用户
任意主机以用户root和密码mypwd连接到mysql服务器
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘mypwd’ WITH GRANT OPTION;
mysql> flush privileges;