MySQL下查看和赋予权限
2024-10-19 02:29:05
磨砺技术珠矶，践行数据之道，追求卓越价值
回到上一级页面： PostgreSQL杂记页 回到顶级页面：PostgreSQL索引页
[作者 高健@博客园 luckyjackgao@gmail.com]
查看权限表字段内容：
mysql> desc mysql.user;
+------------------------+-----------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+---------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(16) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Reload_priv | enum('N','Y') | NO | | N | |
| Shutdown_priv | enum('N','Y') | NO | | N | |
| Process_priv | enum('N','Y') | NO | | N | |
| File_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Show_db_priv | enum('N','Y') | NO | | N | |
| Super_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Repl_slave_priv | enum('N','Y') | NO | | N | |
| Repl_client_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Create_user_priv | enum('N','Y') | NO | | N | |
| Event_priv | enum('N','Y') | NO | | N | |
| Trigger_priv | enum('N','Y') | NO | | N | |
| Create_tablespace_priv | enum('N','Y') | NO | | N | |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int(11) unsigned | NO | | 0 | |
| max_updates | int(11) unsigned | NO | | 0 | |
| max_connections | int(11) unsigned | NO | | 0 | |
| max_user_connections | int(11) unsigned | NO | | 0 | |
| plugin | char(64) | YES | | | |
| authentication_string | text | YES | | NULL | |
| password_expired | enum('N','Y') | NO | | N | |
+------------------------+-----------------------------------+------+-----+---------+-------+
43 rows in set (0.00 sec) mysql>
赋予权限：
mysql> GRANT SELECT, INSERT, DELETE,UPDATE ON *.* TO 'usrabc'@'%';
Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec) mysql>
查看赋予权限的情况：
mysql> SELECT user, host,select_priv, insert_priv, update_priv,delete_priv from mysql.user;
+--------+------------+-------------+-------------+-------------+-------------+
| user | host | select_priv | insert_priv | update_priv | delete_priv |
+--------+------------+-------------+-------------+-------------+-------------+
| root | localhost | Y | Y | Y | Y |
| root | server.gao | Y | Y | Y | Y |
| root | 127.0.0.1 | Y | Y | Y | Y |
| root | ::1 | Y | Y | Y | Y |
| | localhost | N | N | N | N |
| | server.gao | N | N | N | N |
| usrabc | % | Y | Y | Y | Y |
+--------+------------+-------------+-------------+-------------+-------------+
7 rows in set (0.00 sec) mysql>
[作者 高健@博客园 luckyjackgao@gmail.com]
回到上一级页面： PostgreSQL杂记页 回到顶级页面：PostgreSQL索引页
磨砺技术珠矶，践行数据之道，追求卓越价值
最新文章
- 自己瞎捣腾的Win7下Linux安装之路-----图例篇
- 三维网格分割算法（Random Walks）
- Java数据结构——解析算术表达式
- OpenCV源码分析:RGB到其他色彩空间的转换
- makefile 中定义宏位置需要注意一下
- ipconfig
- 深入研究Block用weakSelf、strongSelf、@weakify、@strongify解决循环引用（上）
- C++函数转换成C#函数
- Cocos2d-x教程第(11)讲－利用遮罩(蒙版)CCLayerColor制作新手引导界面(上)
- Web API中使用Dependency Resolver
- 小试 Ninja
- return 返回值
- Jboss安装配置以及相关的问题
- web打印控件Lodop轻松输出清晰的图表和条码
- (惊艳)基于谷底最小值的阈值的图像分割（改进HSV中的H分量可以用imhist(H)提取）
- Linux服务器安装配置Nginx服务器
- 打造高可靠与高性能的React同构解决方案
- Generate PDF in Sourcing through concurrent request，在EBS java并发中调用指定am的方法
- ng-深度学习-课程笔记-17: 序列模型和注意力机制(Week3)
- Phonegap 工程项目介绍