read only user table

[Guest_imported]

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?

 

[devnull22]

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

http://www.photoflux.com

http://www.clickEval.com

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

 

[Guest_imported]

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.

 

[Guest_imported]

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