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
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
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