read only message

2001-11-18 Thread Barbara Ferrell
i am using linux redhat 7.2. on my home computer.. i am logged on as root@localhost. i get a message that my table is read only. i thought the root user had all privileges and i cannot figure out how to give myself the privilege to change and alter my database and tables after i just created

Re: read only message

2001-11-18 Thread Bruce Ferrell
The message means that the databse files themselves have incorrect permissions for the user mysql is running as. ps -ef | grep mysql will show who mysqld is running as. Then check the owership/permissions of the files to see if they are owned by that user. I think you'll find they are not

Re: read only message

2001-11-18 Thread Russell Miller
Have you tried checking the permissions on the .frm files? --Russell - Original Message - From: Barbara Ferrell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November 18, 2001 9:08 AM Subject: read only message i am using linux redhat 7.2. on my home computer.. i am logged