mysql user is read only and how can I change it ?

['chris']

hi

I'm using MySQL version 3.23.52 installed on linux SuSE 8.1

mysql> GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'password';
ERROR 1036: Table 'user' is read only
mysql>

why this user is read only and how can I change it ?

kindly regards
chris

[Patrick Wallek]

If I read this right it is not the user that is read-only it is the 'user' TABLE (the part of the DB that contains the info about the users) that is read-only. You will need to modify the TABLE so that it is something other than read-only.

[Massimo Bianchi]

Hi,
with which user were you logged in ?

I think that user had not the capability to write to the "user" table, but only to do a select (select any table privilege).


Massimo

[Andrew Cowan]

You must be logged in as the "mysql" user, or whatever the name used to install MySql. You can then grant these permissions to other users. The only other thing that could have gone wrong is if you have changed the file permissions on the physical datafile that contains the user table. Did you do the install as "root"?

['chris']

hi

thanks.
now is working.
there was a problem with permissions.

regards
chris

[Laurent Laperrousaz]

You shoul assign points to people who took time to answer you...

All permissions on mySQL are managed on 'mysql' database and all the permissions are described on the 'user' table on the base of where you connect from and with which mysql user.

You can have all precise information on that link:
http://www.mysql.com/doc/en/Adding_users.html