MySql: Table 'X' marked as read only

Cyth · 01-05-2002, 05:22 PM

Hi all,

I have an Visual Basic program connected to an MySql database via ADO which in turn uses MyOdbc.
The MySql database is running separetly on a slack box. The Visual Basic program is running on a Windows 2000 Pro client with Sp2 installed.

When I send a simple UPDATE query it returns "Table 'X' marked as read only" where X is the name of the table.

I haven't marked the table as read only, nor any other weird options. Besides, INSERT statmens works flawless.

I tried to let google guide me, but with no success.

Anyone with experience on this matter?

regards,
Cyth

crabboy · 01-05-2002, 06:35 PM

Check to make sure that your db user has Update-priv permission in the mysql.db table.

Cyth · 01-05-2002, 07:46 PM

Yupp, the user got full permissions.

/Cyth

Cyth · 01-07-2002, 01:57 AM

I looked at it more deeply and found out that I was wrong;

A previous user that I used on the mysql db had all previliges but not the one I use now. So I tried to change the Update_priv column by editing the mysql.user table manually with bin/mysql. When I did that with root, it told me "table user is read only".
I am root, and the actual files have write permissions. What am I doing wrong?

I think the two problems is related in some way..

regards,
Cyth

d3funct · 01-07-2002, 11:04 AM

MYSQL doesn't care if you're root, mysql permissions are granted by mysql not by the system. Try restarting mysqld with the grant tables off mysqld --skip-grant-tables then login as root and flush the privilege table and then provide new privileges to the users as they should be.

Cyth · 01-09-2002, 02:15 PM

Now I've changed the Update_priv to Y but I _still_ don't have access, I get the same error.

Yes, I have restarted the mysql server and I have checked that my change was still there.

Funny..

A fast answer is *really* appreciated,
Cyth

Cyth · 01-09-2002, 02:30 PM

mysql> select user, Update_priv from user;
+------+-------------+
| user | Update_priv |
+------+-------------+
| root | Y |
| root | Y |
| | N |
| | N |
| gun | Y |
+------+-------------+
5 rows in set (0.00 sec)

mysql>
I changed the user perms like this:

GRANT ALL PRIVILEGES ON hotel.* TO gun@"%" IDENTIFIED BY ":P" WITH GRANT OPTION;

Hope this helps,
Cyth

d3funct · 01-17-2002, 01:19 PM

Try restarting mysqld with the grant tables off mysqld --skip-grant-tables then login as root and flush the privilege table and then provide new privileges to the users as they should be.

catlion · 09-07-2004, 09:57 PM

For those who need to solve this problem

Code:

chown mysql:mysql /var/lib/mysql/mysql/*

. Note that mysql:mysql is user/group which is your server works under, and /var/lib/mysql is the Root path in your my.cnf

oobx · 07-12-2011, 11:20 AM

Quote:

Originally Posted by catlion

For those who need to solve this problem :D

Code:

chown mysql:mysql /var/lib/mysql/mysql/*

:D :D. Note that mysql:mysql is user/group which is your server works under, and /var/lib/mysql is the Root path in your my.cnf

Your post triggered another question about permissions in my head. Thank you, seven years later!

These days, you also need to watch out for SELinux. On my RHEL box, I needed the context to be user_u:object_r:mysqld_db_t. Use chcon to change contexts.

ta0kira · 07-12-2011, 12:09 PM

It's interesting that a post 2.5 years too late can be useful 7 years later! You should start a new thread.
Kevin Barry