MySQL創建遠程登陸用戶並授權

用root連接上數據庫進行查看user錶的情况

mysql> select Host,User from mysql.user;
+-----------+---------------+
| Host      | User          |
+-----------+---------------+
| localhost | java_test     |
| localhost | mysql.session |
| localhost | mysql.sys     |
| localhost | root          |
+-----------+---------------+
4 rows in set (0.00 sec)

一共又4個mysql賬號，Host列可以看出來，這些賬號只支持服務器本機連接，現在來創建一個遠程用戶；

mysql> create user test identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> select Host,User from mysql.user;
+-----------+---------------+
| Host      | User          |
+-----------+---------------+
| %         | test          |
| localhost | java_test     |
| localhost | mysql.session |
| localhost | mysql.sys     |
| localhost | root          |
+-----------+---------------+
5 rows in set (0.00 sec)

創建完成，在程序裏面連接發現還是沒有權限，剛才我們知識創建了用戶，還沒有對這個用戶分配權限

mysql> grant all privileges on *.* to 'test'@'%' identified by '123456' with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)

all代錶接受所有操作，比如 select,insert,delete…; . 代錶所有庫下面的所有錶;% 代錶這個用戶允許從任何地方登錄；為了安全期間，這個%可以替換為你允許的ip地址；

然後刷新mysql用戶權限相關錶

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