Privileges Provided by MySQL • PROCESS •With the  PROCESS  privilege, a user has access to information about all threads, even those belonging to other users. •Without the  PROCESS  privilege, nonanonymous users have access to information about their own threads but not threads for other users, and anonymous users have no access to thread information. • PROXY • REFERENCES • RELOAD •Use of the  FLUSH  statement. •Use of  mysqladmin  commands that are equivalent to  FLUSH  operations:  flush-hosts ,  flush- logs ,  flush-privileges ,  flush-status ,  flush-tables ,  flush-threads ,  refresh , and reload . •Use of  mysqldump  options that perform various  FLUSH  operations:  --flush-logs  and  --master- data . •Use of the  RESET MASTER  and  RESET REPLICA | SLAVE  statements. • REPLICATION CLIENT 1192 Enables use of the  SHOW MASTER STATUS ,  SHOW REPLICA | SLAVE STATUS , and  SHOW BINARY LOGS  statements. The  reload  command tells the server to reload the grant tables into memory.  flush-privileges is a synonym for  reload . The  refresh  command closes and reopens the log files and flushes all tables. The other  flush- xxx  commands perform functions similar to  refresh , but are more specific and may be preferable in some instances. For example, if you want to flush just the log files,  flush- logs  is a better choice than  refresh . The  RELOAD  enables the following operations: Creation of a foreign key constraint requires the  REFERENCES  privilege for the parent table. Enables one user to impersonate or become known as another user. See Section 6.2.18, “Proxy Users” . The  PROCESS  privilege also enables use of the  SHOW ENGINE  statement, access to the INFORMATION_SCHEMA InnoDB  tables (tables with names that begin with  INNODB_ ), and (as of MySQL 8.0.21) access to the  INFORMATION_SCHEMA FILES  table. Note The Performance Schema  threads  table also provides thread information, but table access uses a different privilege model. See Section 27.12.21.6, “The threads Table” . The  PROCESS  privilege controls access to information about threads executing within the server (that is, information about statements being executed by sessions). Thread information available using the  SHOW PROCESSLIST  statement, the  mysqladmin processlist  command, the INFORMATION_SCHEMA.PROCESSLIST  table, and the Performance Schema  processlist  table is accessible as follows: