[普通]mysql 远程访问和授权手记

#创建远程访问

create user 'root'@'%' identified by 'root';

alter mysql.user 'root'@'%' identified by 'root';

ALTER user 'root'@'localhost' IDENTIFIED BY 'root';

#MYSQL_NATIVE_PASSWORD 密码认证

ALTER USER 'root'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY 'root'

ALTER USER 'root'@'%' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD root';

#给远程访问赋予权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'root' WITH GRANT OPTION;

flush privileges;