Still Read-only table after granting all privileges

[LTeeple]

Good day,
I copied a table from a server onto my test server, and wish to alter it somewhat. I attempted to ADD COLUMN via the ALTER TABLE command, and got an error:
ERROR 1036: Table 'TABLE' is read only.

So I ensured all privileges, by executing the GRANT command:
GRANT ALL PRIVILEGES ON *.* to root@localhost
IDENTIFIED BY 'pword'; which executed fine.

I then tried to ALTER TABLE again, but am still getting the above error. Any ideas folks?

Thanks for your time


Cheers!
Laura

 

[QatQat]

is it on Linux?
I have had that moving a db from 2000 to linux.
if so you should check file permission settings.

Bye

Qatqat

Life is what happens when you are making other plans.

 

[LTeeple]

It is on a linux machine. I have ensured that file permissions are set properly... I am baffled!

Thanks for your response


Cheers!
Laura

 

[KarveR]

are the db files owned correctly as well ?

rw-rw---- 1 mysql mysql 8622 Jan 6 11:46 REGION.frm
-rw-rw---- 1 mysql mysql 273 Jan 6 11:46 REGION.MYD
-rw-rw---- 1 mysql mysql 3072 Jan 6 12:55 REGION.MYI

chown mysql tablename.*
chgrp myslq tablename.*


______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.