Changes

Jump to: navigation, search

MySQL Users and Security

210 bytes removed, 14:48, 29 October 2007
User Privileges
<tr>
<td>CREATE USER</td>
<td>Enable the use of CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES.</td>
</tr>
<tr>
<tr>
<td>FILE</td>
<td>Enable the use of SELECT ... INTO OUTFILE and LOAD DATA INFILE
</td>
<tr>
<td>INDEX</td>
<td>Enable the use of CREATE INDEX and DROP INDEXstatements
</td>
</tr>
<tr>
<td>LOCK TABLES</td>
<td>Enable the use of LOCK TABLES on tables for which the user has the SELECT privilege</td>
</tr>
<tr>
<td>PROCESS</td>
<td>Enable the user to see all processes with SHOW PROCESSLIST
</td>
</tr>
<tr>
<td>REPLICATION SLAVE</td>
<td>Needed for replication slaves (reads binary log events from the master)</td>
</tr>
<tr>
<tr>
<td>SUPER</td>
<td>Enable the use of CHANGE MASTER, KILL, PURGE MASTER LOGS, and SET GLOBAL  statements, the mysqladmin debug command; allows single connection if max_connections is reached</td>
</tr>
<tr>

Navigation menu