MySQL如何使用GRANT授权某用户浏览和修改表权限运作
发布时间：2021-12-27 10:03:10 所属栏目：MySql教程 来源：互联网
导读：小编给大家分享一下MySQL如何使用GRANT授权某用户浏览和修改表权限操作，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！ 下面的例子是授权logger用户查询，插入和修改test数据库表记录,但不能删除的一个例子: C:Usersduansfmysql -u ro
|
小编给大家分享一下MySQL如何使用GRANT授权某用户浏览和修改表权限操作，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！ 下面的例子是授权logger用户查询，插入和修改test数据库表记录,但不能删除的一个例子: C:Usersduansf>mysql -u root -p Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.5.13 MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. mysql> use test Database changed mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | workinfo | +----------------+ 1 row in set (0.03 sec) mysql> select * from workinfo; Empty set (0.12 sec) --表记录为空 mysql> grant select,insert,update on test.workinfo to logger@localhost identified by 'timber'; --授权logger用户访问和修改test数据库的workinfo表 Query OK, 0 rows affected (0.14 sec) mysql> quit Bye C:Usersduansf>mysql -h localhost -u logger -p --用logger用户登录数据库 Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 3 Server version: 5.5.13 MySQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. mysql> mysql> select * from workinfo; --可以查询 Empty set (0.12 sec) mysql> desc workinfo; +----------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+----------------+ | id | int(10) | NO | PRI | NULL | auto_increment | | name | varchar(20) | NO | | NULL | | | type | varchar(10) | YES | | NULL | | | address | varchar(50) | YES | | NULL | | | tel | varchar(20) | YES | | NULL | | | wages | int(11) | YES | | NULL | | | contents | tinytext | YES | | NULL | | | extra | text | YES | | NULL | | +----------+-------------+------+-----+---------+----------------+ 8 rows in set (0.02 sec) mysql> insert into workinfo values(3,'chenfeng','type','zhengzhou','123456',22,1,1); --有插入权限 Query OK, 1 row affected (0.13 sec) mysql> select * from workinfo; --有查询权限 +----+----------+------+-----------+--------+-------+----------+-------+ | id | name | type | address | tel | wages | contents | extra | +----+----------+------+-----------+--------+-------+----------+-------+ | 3 | chenfeng | type | zhengzhou | 123456 | 22 | 1 | 1 | +----+----------+------+-----------+--------+-------+----------+-------+ 1 row in set (0.00 sec) mysql> delete from workinfo where id=3; --无删除权限，以下是报错信息 ERROR 1142 (42000): DELETE command denied to user 'logger'@'localhost' for table 'workinfo' 看完了这篇文章，相信你对“MySQL如何使用GRANT授权某用户浏览和修改表权限操作”有了一定的了解。 （编辑：源码网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
