Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

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

'chris'
Super Advisor

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

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
5 REPLIES
Patrick Wallek
Honored Contributor

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

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
Honored Contributor

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

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
Honored Contributor

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

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'
Super Advisor

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

hi

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

regards
chris
Laurent Laperrousaz
Regular Advisor

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

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