'Read only error "

[jngau]

hello friends

i have installed mysql version---3.23 and getting the error as.......

ERROR 1036: Table 'student' is read only

plz help me

[ronverdonk]

How did you define and fill that table? Did you copy if from a table dump or something like that. Or put a lock on it without rremoving that lock? Please show.

Ronald :cool:

[jngau]

How did you define and fill that table? Did you copy if from a table dump or something like that. Or put a lock on it without rremoving that lock? Please show.

Ronald :cool:

mysql> create table student1(id int(5), name varchar(10), rolno int(5));
Query OK, 0 rows affected (0.16 sec)
mysql> desc student1;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(5)      | YES  |     | NULL    |       |
| name  | varchar(10) | YES  |     | NULL    |       |
| rolno | int(5)      | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.02 sec)

mysql> insert into student1 values(1, 'gaurav',18);
ERROR 1036: Table 'student1' is read only
mysql>

this wat i did now can u explain me plz

[metaglossary]

Are you moving tables between slightly different versions of MySQL? If so, I was having the same problem (and getting the same error message). Try running the "mysql upgrade" command:

http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html