MySQL 如何创建权限有限的用户
创建权限有限的MySQL用户,遵循以下语法 –
CREATE USER 'yourUserName'@'yourHostName' IDENTIFIED BY 'yourPassword';
Mysql
设置用户有限权限的语法如下 –
GRANT SELECT,INSERT,UPDATE等 REFERENCES
ON yourDatabaseName.* TO 'yourUserName'@'yourHostName';
Mysql
实现以上语法以创建权限有限的MySQL用户 –
mysql> CREATE USER 'David'@'localhost' IDENTIFIED BY 'david';
Query OK, 0 rows affected (0.20 sec)
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, CREATE, REFERENCES
ON test.* TO 'David'@'localhost';
Query OK, 0 rows affected (0.21 sec)
Mysql
检查是否已创建名为’David’的用户。
mysql> select user, host from MySQL.user;
Mysql
这将产生以下输出 –
+------------------+-----------+
| user | host |
+------------------+-----------+
| Bob | % |
| User2 | % |
| mysql.infoschema | % |
| mysql.session | % |
| mysql.sys | % |
| root | % |
| @UserName@ | localhost |
| Adam Smith | localhost |
| David | localhost |
| James | localhost |
| John | localhost |
| John Doe | localhost |
| User1 | localhost |
| am | localhost |
| hbstudent | localhost |
| mysql.infoschema | localhost |
| mysql.session | localhost |
+------------------+-----------+
17行 (0.00秒)。
Mysql
阅读更多:MySQL 教程