mysql installed by macports mysql.user is empty

[Ryan Schmidt]

On Mar 28, 2011, at 10:56, Alex Yang wrote:

>  I use macport install mysql-5 in mac snow leopard, after changging
>  permision of mysql directory under var/run and var/db,

You should not have needed to change the permissions of the directories; they should already have been correct after installing the mysql5-server port. Did you install the mysql5-server port, or only the mysql5 port?

> I can run
>  mysql_install_db, but I cannot change root password or run mysql_security,
>  I log in mysql under skip-grant, I see mysql.user is empty-set. Is there
>  anyway to fix that?
> 
>  second question is, I use root run mysql, what user and group mysql use to
>  access files.