Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Simon Lee
February 7, 2006, 6:12 am
rate this thread
I moved all mysql database data to the new server Redhat 9. and set the
right of the files to be mysql.mysql (chown) and 660(chmod), and also grant
all privileges to the corresponding databases, However, when I delete some
rows of data, the error is prompted out
"ERROR 1036: Table 'xxx' is read only." Why? Anyway, I create a another new
database and add some tables into it , Then the delete function is OK. It is
very strange that all privilege are the same when I compare those of all old
database with those just created. Please advise me how to solve the problem
on the old databases, thanks.
Re: mysql server problem
if your user is allowed to modify table data!
You should use a good client ( http://dev.mysql.com/ )
"Error: 1036 SQLSTATE: HY000 (ER_OPEN_AS_READONLY)
Message: Table '%s' is read only"
This means that the database itself might nto allow you to access the
This is not a php question at all.