mysql_native_password

mysql5创建远程管理员

GRANT ALL PRIVILEGES ON *.* TO "root"@"%" IDENTIFIED BY "password" WITH GRANT OPTION;
FLUSH PRIVILEGES;

mysql8

create user 'root2'@'%' identified by 'password';
grant all privileges on *.* to  'root2'@'%' with grant option; 
FLUSH PRIVILEGES;