Re: mysql.users read only?

2003-01-14 Thread gerald_clark
Check that mysql has write privileges at the operating system level. Loren McDonald wrote: Just tried. Nope... mysql grant all privileges on mysql.* to ext identified by 'ext1tex2' with grant option; ERROR 1036: Table 'user' is read only

re: RE: mysql.users read only?

2003-01-14 Thread Victoria Reznichenko
On Tuesday 14 January 2003 01:45, Loren McDonald wrote: Just tried. Nope... mysql grant all privileges on mysql.* to ext identified by 'ext1tex2' with grant option; ERROR 1036: Table 'user' is read only Check permissions on the privilege table files, like host.frm, user.frm etc in the

RE: mysql.users read only?

2003-01-14 Thread Loren McDonald
MisterrMac Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 9:20 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: mysql.users read only? Check that mysql

Re: mysql.users read only?

2003-01-13 Thread gerald_clark
Does the user 'mysql' have write access to the mysql database and files? Loren McDonald wrote: I’m not sure what has gone wrong but the mysql.users table is set as read only. I am trying to grant user privileges but can’t because of this. How can I change the status so that I can add to it?

RE: mysql.users read only?

2003-01-13 Thread Loren McDonald
Just tried. Nope... mysql grant all privileges on mysql.* to ext identified by 'ext1tex2' with grant option; ERROR 1036: Table 'user' is read only -- Loren McDonald AKA MisterrMac Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com Does the user 'mysql' have write