220996 - The grant statement needs "lock tables" (section "Setting up the MySQL-Database")

Status: RESOLVED DUPLICATE of bug 195424

(Bugzilla :: Documentation, defect)

Description

[Andreas Höfler]

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5b; MultiZilla v1.5.0.2Beta) Gecko/20030827 WebWasher 3.3
Build Identifier: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5b; MultiZilla v1.5.0.2Beta) Gecko/20030827 WebWasher 3.3

The GRANT statement now also needs to have the LOCK TABLES privilege in it.
checksetup.pl needs this and so do many other parts of Bugzilla 2.17.4.

Reproducible: Always

Steps to Reproduce:

Comment 1

[Vlad Dascalu]

Attachment: Patch

Comment 2

[Vlad Dascalu]

<-- me

Comment 3

[Christian Reis]

Comment on attachment 132742 [details] [diff] [review]
Patch

This is only required for MySQL 4 -- on MySQL 3 there is no LOCK TABLES
permissions and it raises an SQL error if you try to do so.

MySQL 3 reference at 
http://www.dwam.net/docs/mysqle3.23/manuel_GRANT.html#GRANT

Related discussion at http://www.oreillynet.com/cs/user/view/cs_msg/19832

Comment 4

[Vlad Dascalu]

Mentioning the MySQL 3 versus 4 distinction into BZ documentation would be the
right path here?

Comment 5

[Christian Reis]

Andreas, am I correct in assuming you're using MySQL 4? 

If so, it would be definitely the case, Vladd.

Comment 6

[Dave Miller [:justdave]]

Did anyone look at the current docs?  ;)


*** This bug has been marked as a duplicate of 195424 ***