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
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
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
Does the user 'mysql' have write access to the mysql database and files?
Loren McDonald wrote:
Im not sure what has gone wrong but the mysql.users table is set as
read only. I am trying to grant user privileges but cant because of
this. How can I change the status so that I can add to it?
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