

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Which tables are used to control the privileges of MySQL database server?
When we install MySQL server, a database named MySQL created automatically. This MySQL database contains five main grant tables with the help of which MySQL server can control the privileges of MySQL database server. These tables are as follows −
user table
This table contains user account and global privileges columns. MySQL uses the user table to either accept or reject a connection from a host. A privilege granted in the user table is effective to all databases on the MySQL server.
db table
This table contains database-level privileges. MySQL uses the db table to determine which database a user can access and from which host. A privilege granted at the database level in the db table applies to the database and all objects belong to that database e.g., tables, triggers, views, stored procedures, etc.
table_priv
This table contains table-level privileges. A privilege granted in the table_priv table applies to the table and its columns.
columns_priv
This table contains column-level privileges. A privilege granted in the columns_priv table applies only to a specific column of a table.
procs_priv
This table contains stored functions and stored procedures privileges.
- Related Questions & Answers
- How to add super privileges to MySQL database?
- Grant all privileges of a database to a MySQL user?
- How can we analyze the tables of a particular database from MySQL Server command line?
- Which PHP function is used to select a MySQL database?
- What kinds of programs are available in MySQL database to manage MySQL server?
- How to show all the tables present in the database and server in MySQL using Python?
- Which PHP function is used to disconnect from MySQL database connection?
- How can we get the list of tables in a particular database from MySQL Server command line?
- How to get the size of the tables of a MySQL database?
- How to copy tables or databases from one MySQL server to another MySQL server?
- How to count the number of tables in a MySQL database?
- How to get the list of tables in default MySQL database?
- While connecting to one MySQL database, how can I see the list of tables of other MySQL database?
- Which property is used in CSS to control the repetition of an image in the background?
- Which property is used in CSS to control the position of an image in the background?