| Title | MySQL privilege required and not documented |
| Status | closed |
| Priority | essential |
| Assigned user | David Jones |
| Organization | Ravenbrook |
| Description | Some versions of MySQL have a new privilege: Lock_table_priv. This is required by the P4DTI MySQL user (the P4DTI replicator locks tables during polls). This requirement is not documented in the AG. |
| Analysis | This is Perforce job job011359 [1]. Figure out the version dependency of MySQL here, add to the AG to document this requirement. In the privilege is Lock_tables_priv. In a running MySQL instance it is possible to see whether this privilege is required by using the command "describe mysql.user;". Said table has a column for each (user) privilege. Finding out which version the privilege was introduced is hard. However, the notes on upgrading, Upgrading From Version 3.23 to 4.0 [2], strongly imply that the new privilege (and a raft load of others) was added then. |
| How found | customer |
| Evidence | [1] <http://info.ravenbrook.com/mail/2003/06/13/23-15-00/0.txt>[2] < http://www.mysql.com/doc/en/Upgrading-from-3.23.html> |
| Observed in | 2.0.0 |
| Introduced in | 0.5.0 |
| Created by | Nick Barnes |
| Created on | 2003-08-05 17:21:05 |
| Last modified by | David Jones |
| Last modified on | 2003-08-07 16:13:44 |
| History | 2003-08-05 NB Created. 2003-08-07 DRJ Notes about Lock_tables_priv |
| Change | Effect | Date | User | Description |
|---|---|---|---|---|
| 52669 | closed | 2003-08-07 15:15:11 | David Jones | p4dti: Lock_tables_priv in AG |