
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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 Articles
- 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?
- How to show all the tables present in the database and server in MySQL using Python?
- What kinds of programs are available in MySQL database to manage MySQL server?
- How can we get the list of tables in a particular database from MySQL Server command line?
- How to copy tables or databases from one MySQL server to another MySQL server?
- How to get the size of the tables of a MySQL database?
- How to get the list of tables in default MySQL database?
- How to count the number of tables in a MySQL database?
- While connecting to one MySQL database, how can I see the list of tables of other MySQL database?
- Which PHP function is used to select a MySQL database?
- List down all the Tables in a MySQL Database
- How to check table status of the tables in a particular MySQL database?
- Which PHP function is used to disconnect from MySQL database connection?
