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
