Privileges Provided by MySQL • REPLICATION SLAVE • SELECT • SHOW DATABASES • SHOW VIEW • SUPER • SHUTDOWN 1193 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 Enables use of the  SHUTDOWN  and  RESTART  statements, the  mysqladmin shutdown  command, and the  mysql_shutdown() C API function. Enables use of the  SHOW CREATE VIEW  statement. This privilege is also needed for views used with EXPLAIN . 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 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. The  SELECT  privilege is needed for tables or views used with  EXPLAIN , including any underlying tables in view definitions. 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. 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; 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. Caution