mysql通过特定的用户名和密码来远程授权数据库访问

1、创建数据库用户：
    create user 'yw'@'%' identified by 'yw0921@#$';

2、授权数据库访问：

登录MySQL

    mysql>grant all privileges on db_name.db_table to 'user_name'@'remote_address' identified by 'password' with grant option;

    名词解释：

    db_name:MySQL服务器上的数据库名

    db_table:MySQL服务器上的数据表名

    user_name:远程主机的登录用户名

    remote_address:远程主机IP地址

    password:远程主机的登录密码

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'121.19.130.323' IDENTIFIED BY 'yw0921@#$' WITH GRANT OPTION;

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'121.19.130.324' IDENTIFIED BY 'yw0921@#$' WITH GRANT OPTION;

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'121.19.130.325' IDENTIFIED BY 'yw0921@#$' WITH GRANT OPTION;

3、8.0版本mysql

授权username用户在databasename上的权限,all代表所有,可分为INSERT,SELECT,UPDATE等权限,%代表任何ip都可访问该数据库.

grant all privileges on databasename.* to 'username'@'%';
 

3、刷新授权：
    FLUSH   PRIVILEGES;

备注：

最后一步至关重要，不刷新这样就不会生效