mysql创建远程访问用户

创建过程如下：

1. 创建用户

create user 用户; 

2. 授权

GRANT ALL PRIVILEGES ON *.* TO 用户@”%” IDENTIFIED BY ‘密码’ WITH GRANT OPTION; 

3. 生效

flush privileges;

create user admin; 
GRANT ALL PRIVILEGES ON *.* TO admin@"%" IDENTIFIED BY 'admin' WITH GRANT OPTION;
flush privileges;