content_image/819098.jpg
• REPLICATION SLAVE 

Enables the account to request updates that have been made to databases on the replication source server, using the SHOW REPLICAS | SHOW SLAVE HOSTS , SHOW RELAYLOG EVENTS , and SHOW BINLOG EVENTS  statements. This privilege is also required to use the mysqlbinlog  options --read- from-remote-server  ( -R ) and --read-from-remote-master . Grant this privilege to accounts that are used by replicas to connect to the current server as their replication source server. 

• SELECT 

Enables rows to be selected from tables in a database. SELECT  statements require the SELECT  privilege only if they actually access tables. Some SELECT  statements do not access tables and can be executed without permission for any database. For example, you can use SELECT  as a simple calculator to evaluate expressions that make no reference to tables: 

SELECT 1+1; SELECT PI()*2; 

The SELECT  privilege is also needed for other statements that read column values. For example, SELECT  is needed for columns referenced on the right hand side of col_name = expr  assignment in UPDATE  statements or for columns named in the WHERE  clause of DELETE  or UPDATE  statements. 

The SELECT  privilege is needed for tables or views used with EXPLAIN , including any underlying tables in view definitions. 

• SHOW DATABASES 

Enables the account to see database names by issuing the SHOW DATABASE  statement. Accounts that do not have this privilege see only databases for which they have some privileges, and cannot use the statement at all if the server was started with the --skip-show-database  option. 

<img src='content_image/819098.jpg'>

• SHOW VIEW 

## Caution 

Because any static global privilege is considered a privilege for all databases, any static global privilege enables a user to see all database names with SHOW DATABASES  or by examining the SCHEMATA  table of INFORMATION_SCHEMA , except databases that have been restricted at the database level by partial revokes. 

Enables use of the SHOW CREATE VIEW  statement. This privilege is also needed for views used with EXPLAIN . 

• SHUTDOWN 

Enables use of the SHUTDOWN  and RESTART  statements, the mysqladmin shutdown  command, and the mysql_shutdown() C API function. 

• SUPER 

SUPER  is a powerful and far-reaching privilege and should not be granted lightly. If an account needs to perform only a subset of SUPER  operations, it may be possible to achieve the desired privilege set by 

