<div>
I think the problem here is in &quot;LOCK TABLES&quot; it is a globle or database levele privilege, you can't grant it ON spcific table. You must do it &nbsp;a globle or in database level but not for table<br />
<br />

<pre><code id="code-4801770">GRANT SELECT, INSERT, UPDATE, DELETE ON interchange.sharkey TO clearing_job@localhost;

GRANT LOCK TABLES ON interchange TO clearing_job@localhost;
</code></pre>
</div>


I think the problem here is in "LOCK TABLES" it is a globle or database levele privilege, you can't grant it ON spcific table. You must do it  a globle or in database level but not for table



GRANT SELECT, INSERT, UPDATE, DELETE ON interchange.sharkey TO clearing_job@localhost;

GRANT LOCK TABLES ON interchange TO clearing_job@localhost;


<div>
I agree it would seem that way however the manual at the link below says that the context for &quot;LOCK TABLES&quot; is &quot;tables.&quot; <br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html" rel="ugc">http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html</a><br />
<br />
So are you saying the manual is wrong? (Or maybe I'm reading it wrong?)
</div>


I agree it would seem that way however the manual at the link below says that the context for "LOCK TABLES" is "tables."

http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html [http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html]

So are you saying the manual is wrong? (Or maybe I'm reading it wrong?)

<div>
<div class="content wysiwyg-content">
What is it about the below query that's illegal??<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html" rel="ugc">http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html</a><br />
<br />

<pre><code id="code-10-26689091-1">GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON interchange.sharkey TO clearing_job@localhost;

ERROR 1144 (42000): Illegal GRANT/REVOKE command; please consult the manual to see which privileges can be used</code></pre>
<br />
Thanks,<br />
<br />
<a href="http://www.t1shopper.com/" rel="ugc">http://www.t1shopper.com/</a>
</div>
</div>


What is it about the below query that's illegal??

http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html

(CODE)

Thanks,

http://www.t1shopper.com/ (http://www.t1shopper.com/)

MySQL &gt; ERROR 1144 &gt; Illegal GRANT/REVOKE command

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL &gt; ERROR 1144 &gt; Illegal GRANT/REVOKE command

MySQL > ERROR 1144 > Illegal GRANT/REVOKE command