查看用户及连接:
localhost 为本地连接
% 可远程连接
select user,host from mysql.user;
*1 创建用户
```
create user 'username'@'%' identified by 'password';
```
*2 赋权
```
grant all on *.* to 'username'@'%';
```
*3 刷新
```
flush privileges;
查看用户及连接:
localhost 为本地连接
% 可远程连接
select user,host from mysql.user;
*1 创建用户
```
create user 'username'@'%' identified by 'password';
```
*2 赋权
```
grant all on *.* to 'username'@'%';
```
*3 刷新
```
flush privileges;