1. 用navicat创建一个库
  2. 用navicat的命令行运行下面的命令
1
2
3
4
5
6
7
8
mysql> create USER 'ry386'@'%' IDENTIFIED BY '66668888';
Query OK, 0 rows affected (0.01 sec)

mysql> grant all on ry386.* to 'ry386'@'%' with grant option;
Query OK, 0 rows affected (0.04 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)