Re: Unable to get lock on tables for 4.0.1

2002-04-25 Thread Nick Gilliam
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

Re: Unable to get lock on tables for 4.0.1

2002-04-24 Thread Nick Gilliam
Nick Gilliam wrote: > > > Egor Egorov wrote: > >> Nick, >> Wednesday, April 24, 2002, 3:59:26 PM, you 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 user

Re: Unable to get lock on tables for 4.0.1

2002-04-24 Thread Nick Gilliam
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. T

Unable to get lock on tables for 4.0.1

2002-04-24 Thread Nick Gilliam
I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am unable to bet a lock on a table with any userid except root. Here is my environment: Sun 450 Solaris 2.8 MyISAM tables Any ideas on how this problem could be solved? Thanks, Nick Gilliam