mysql5 installation cant put password

[erchache2000.macports@…]

I install mysql5 and i cant enter with mysql because ask for a password :-S

I rerun daemon with option /opt/local/libexec/mysqld --basedir=/opt/local --datadir=/opt/local/var/db/mysql5 --user=_mysql --log-error=/opt/local/var/db/mysql5/erchache.us.es.err --pid-file=/opt/local/var/db/mysql5/erchache.us.es.pid --skip-grant-tables

and can enter.

I use UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES;

And dont save password.

How i can solve it? is it a mysql 5 compilation problem?

[jmroot (Joshua Root)]

Please remember to fill in the Port field and cc the maintainer. As per the ticket guidelines, the High priority is reserved for the use of MacPorts team members.

[erchache2000.macports@…]

Solved!

I reinstall mysql databases with mysql_install_db --user=_mysql and runs.

It's a user problem, is _mysql not mysql.

You can close this issue.

Thanks a lot.

[ryandesign (Ryan Carsten Schmidt)]

FYI, complete MySQL setup instructions for MacPorts are in our wiki.