P4DTI issue job000756

TitleMySQL privilege required and not documented
Assigned userDavid Jones
DescriptionSome 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.
AnalysisThis 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 foundcustomer
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 in2.0.0
Introduced in0.5.0
Created byNick Barnes
Created on2003-08-05 17:21:05
Last modified byDavid Jones
Last modified on2003-08-07 16:13:44
History2003-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