OK.... now I feel dumb.... I thought I had checked that... but what has
happened was that there were multiple instances of the file... so while I
changed the write access on the mysql files I thought were being used....
it still didn't work... but low and behold... there was another directory
with the "real" mysql files (well actually several instances... but
apparently we don't feel the need to delete old files!!).... so thank
you... it is now fixed!!
Cheers,
Sean
Gerald Clark
<gerald_clark@suppliersy To:
[EMAIL PROTECTED]
stems.com> cc: Nessi <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
Subject: Re: URGENT!!!! MySQL
user table is read only...
06/20/01 01:53 PM
ls -l /var/mysql/mysql/user.*
Replace above path with actual path on your system.
Does mysql have write privileges on the files?
[EMAIL PROTECTED] wrote:
> Unfortunately I have tried that. Attempted to GRANT all privelages to
the
> root user.... it failed with the same error message stating that the
Table
> "user" is read only.
>
> UGH!!!! Too frustrating!!
>
>
>
>
>
>
> Nessi
> <php@elvandar To:
[EMAIL PROTECTED]
> .de> cc: [EMAIL PROTECTED]
> Subject: Re: URGENT!!!!
MySQL user table is read only...
> 06/20/01
> 11:23 AM
>
>
>
>
>
> Why dont you use the GRANT command?
>
> GRANT ALL ON database.* TO newuser@localhost IDENTIFIED BY 'password';
> FLUSH PRIVILEGES;
>
> Something like that...
>
> Cheers, Nessi
>
>
> At 15:55 20/06/01 , you wrote:
>
>> MySQL newbie question here!!
>>
>> I have MySQL installed on Red Hat Linux 7. I have a Test, Backup and
Live
>> environment. All with the same installations of Linux, MySQL and CF. The
>> problem that I am having is that I am trying to create a new database
user
>> in the table "user" in MySQL. It works find in my Test and Backup
>> Environment... but for some reason, my Live environment reports back
that
>> the table is read only.
>>
>> --------------------------------------------------------
>> mysql>USE mysql;
>> mysql>INSERT INTO user (Host, User, Password)
>> ->VALUES ("localhost", "cfuser", PASSWORD("XXXX"));
>> ERROR 1036: Table 'user' is read only
>> ---------------------------------------------------------
>>
>> If anyone could help me it would be greatly, greatly appreciated!! I
>
> think
>
>> I may have to throw my server out the window soon!!
>>
>> Thanks in advance...
>> Sean Blenkhorn
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
>
>
> ---------------------------------------------------------------------
> 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
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
