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