content_image/845250.jpg
• PROCESS 

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: 

•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. 

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

## 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 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. 

• PROXY 

Enables one user to impersonate or become known as another user. See Section 6.2.18, “Proxy Users” . 

• REFERENCES 

Creation of a foreign key constraint requires the REFERENCES  privilege for the parent table. 

• RELOAD 

The RELOAD  enables the following operations: 

•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 . 

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 . 

•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 

Enables use of the SHOW MASTER STATUS , SHOW REPLICA | SLAVE STATUS , and SHOW BINARY LOGS  statements. 

