mysql创建用户并授予远程访问

创建用户为：yby
密码为：123
1、创建用户：CREATE USER 'yby'@'%' IDENTIFIED BY '123';

2、授权：GRANT ALL PRIVILEGES ON *.* TO ‘yby’@‘%’

3、刷新权限：FLUSH PRIVILEGES;

4、alter user 'yby'@'%' identified with mysql_native_password by '123';

5、刷新权限：FLUSH PRIVILEGES;