current position：Home>What are the MySQL permission tables?
What are the MySQL permission tables?
2022-02-04 16:48:24 【Alibaba cloud Q & A】
mysql What are the permission tables ？
Take the answer 1：
MySQL The server controls the user's access to the database through the permission table , The authority list is stored in mysql In the database , from mysql_install_db Script initialization . These authority tables are user,db,table_priv,columns_priv and host.
user Permissions on the table ： Record the user account information allowed to connect to the server , The permissions in it are global .
db Permissions on the table ： Record the operation authority of each account on each database .
table_priv Permissions on the table ： Record data table level operation authority .
columns_priv Permissions on the table ： Record the operation authority of data column level .
host Permissions on the table ： coordination db Permission table controls database level operation permission of given host more carefully . This permission table is not subject to GRANT and REVOKE Statement impact .
author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you.
The sidebar is recommended
- MFC project operation error is not a class or namespace
- main. JS introduces Ant Design Vue
- Can some Java dictionaries store null?
- I need HTML when downloading the boost library with WGet on CentOS tar
- [test development] knowledge points - spring cache + redis is used to cache data in the project
- VO entity deposit value is empty? VO entity content data is empty
- Logic of process scheduling in Linux kernel source code analysis
- How to open a file with relative path in C + + under QT environment
- 30000 words to talk about redis (VI)
- It's great to use debug a!
guess what you like
Netcom infinite integral code
How to find element label in MATLAB
2021 is gone, and 2022 is my year-end summary of 2021
How to use wechat applet for this page
Why is the second% s not output
Badboy recording script website can't be opened in ie. why can't badboy record after changing the default browser?
fatal error LNK1113: invalid machine type
Crazy God said that there was a 404 problem in the ssmbuild project in Java
What is the spark job submission process?
How about the performance comparison of query acceleration in maxcompute?
- What is a database connection pool?
- What is the workflow of spark streaming and how is it different from storm?
- What is the application scenario of streaming data writing in maxcompute?
- What are the source databases supported by DTS self built Mysql to synchronize to RDS MySQL?
- What is the process of establishing a connection between an application and a database?
- What are the target databases supported by DTS self built Mysql to synchronize to RDS MySQL?
- What are the differences and connections between the ML and mllib packages of spark?
- What are the benefits of database connection pooling?
- What are the application scenarios of query acceleration in maxcompute?
- What are the prerequisites for DTS self built Mysql to synchronize to RDS MySQL?
- How does MySQL query statements?
- What are the similarities and differences between yarn cluster and yarn client?
- What are the restrictions on the source database of DTS self built MySQL synchronized to RDS MySQL?
- What is the difference between map and mappartitions?
- What database server performance analysis methods and commands does MySQL have?
- What are the other limitations of DTS self built MySQL synchronization to RDS MySQL?
- What are the advantages of real-time data processing based on maxcompute?
- What is the difference between MySQL blob and text?
- What is the description of the special case of DTS self built MySQL synchronizing to RDS MySQL?
- What types of locks are there in MySQL?
- DTS self built MySQL synchronizes to RDS. What synchronization architectures does MySQL support?
- Android source code analysis Series 1 - activity startup and interface loading, HTML5 mobile terminal development interview
- What are the similarities and differences between worker and excutor?
- Android source code analysis: implementation principle of lrucache caching mechanism, self-evaluation of Android development resume
- MySQL field name batch case conversion, Java work in 2021 may be more difficult to find
- DTS self built MySQL synchronizes to RDS. What SQL operations does MySQL support synchronization?
- MySQL Optimization: Performance Analysis of like and = in where, Java Architect growth express updated to
- What is ECS (Elastic Compute service)?
- What are the differences among the three Android annotation frameworks dagger, hilt and Koin?, Retrofit benefits
- What is the difference between MySQL hash index and B + tree?
- Why ECS?
- What are the permission requirements for DTS self built Mysql to synchronize to RDS MySQL database account?
- What is the difference between MySQL inner connection, left connection and right connection?
- What are the two shared variables provided by spark?
- What does optimizing shard number mean?
- What are the four components of Hadoop?
- DTS self built MySQL is synchronized to RDS MySQL database. What is the method of account creation and authorization?
- What are the main functional components of ECS?
- What are the common billing methods for ECS?
- Why do we need MapReduce?