Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

read only user table

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I've just installed mysql on a mac running osx, but I'm having trouble doing anything with the user table after installation. Every time I try changing the password (it's still open for root and insecure) I get the message telling me the user table is read only.

How do I change this so that I can set the root password?
 
Hi lelanmyrick,
how did you change the password for root?
did you use an UPDATE statement? if so , you need to run a
"flush privileges" statement.

cheers
devnull22

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !
 
I tried using mysqladmin and I tried update. I never got to the point of being able to flush privileges because I got the errors on doing the mysqladmin and update.
 
I think this is a unix/linux thing.Make sure to assign the files in the data directory to the right users(chown):
Examples:
GOOD:
drwxrwx--- 2 mysql mysql 4096 Oct 19 13:19 mysql
drwxrwx--- 2 mysql mysql 4096 Oct 3 20:30 test

WRONG:
drwxr-xr-x 2 root root 4096 Mar 18 12:55 mysql
drwx------ 2 root root 4096 Mar 18 12:55 test
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top