MySQL 如何创建权限有限的用户

MySQL 如何创建权限有限的用户

创建权限有限的MySQL用户,遵循以下语法 –

CREATE USER 'yourUserName'@'yourHostName' IDENTIFIED BY 'yourPassword';
Mysql

设置用户有限权限的语法如下 –

GRANT SELECTINSERTUPDATE 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 教程

Python教程

Java教程

Web教程

数据库教程

图形图像教程

大数据教程

开发工具教程

计算机教程

登录

注册