Egor Egorov wrote:
>Nick,
>Wednesday, April 24, 2002, 10:52:28 PM, you wrote:
>
>NG> Nick Gilliam wrote:
>
>>>Egor Egorov wrote:
>>>
>>>>NG> I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which
>>>>I am NG> unable to bet a lock on a table with any userid except root.
>>>>
>>>>NG> Here is my environment:
>>>>NG> Sun 450
>>>>NG> Solaris 2.8
>>>>NG> MyISAM tables
>>>>
>>>>NG> Any ideas on how this problem could be solved?
>>>>
>>>>Since version 4.0 user must have SELECT, UPDATE, DELETE, INSERT
>>>>privileges to lock tables.
>>>>
>>>>NG> Thanks,
>>>>NG> Nick Gilliam
>>>>
>>>Thanks for the reply. The user has the following privileges: SELECT,
>>>UPDATE, CREATE, INSERT, DELETE, DROP, INDEX, REFERENCES, ALTER. The
>>>user has these same privileges for every table in the database, but
>>>this is the only one he cannot lock. This was not an initial problem
>>>but occurred later.
>>>
>
>NG> I just determined that only the root user can lock tables. No other
>NG> user can at this time get a lock on any table. Help!
>
>Hm ... I tested .. it works fine for me ...
>What error did you get when your user tried to lock tables?
>
Here is the error message:
Error
SQL-query :
Lock Table bugs write
MySQL said:
select command denied to user: 'bugs@localhost' for table 'bugs'
or if a read is attempted:
Error
SQL-query :
Lock Table bugs read
MySQL said:
select command denied to user: 'bugs@localhost' for table 'bugs'
I saw somewhere that perhaps this problem does not exist for 4.0.2 but I
have been unable to found the source for 4.0.2.
Also, when I originally installed MySQL, this error was not present.
Oddly, the error started to occur at about the same time on two
different machines (both Sun 450s). One machine is 4.0.0 and the other
4.0.1. As you can probably tell, I am using MySQL for the backend to
Bugzilla. This error occurs for the "test" database also.
Thanks for any help in resolving this matter.
Nick
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
