New Ticket     Tickets     Wiki     Browse Source     Timeline     Roadmap     Ticket Reports     Search

Ticket #26749 (closed defect: worksforme)

Opened 4 years ago

Last modified 4 years ago

mysql5 installation cant put password

Reported by: erchache2000.macports@… Owned by: ryandesign@…
Priority: Normal Milestone:
Component: ports Version: 1.9.1
Keywords: Cc:
Port: mysql5

Description

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?

Change History

comment:1 Changed 4 years ago by jmr@…

  • Priority changed from High to Normal
  • Owner changed from macports-tickets@… to ryandesign@…
  • Port set to mysql5

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.

comment:2 Changed 4 years ago by 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.

comment:3 Changed 4 years ago by ryandesign@…

  • Status changed from new to closed
  • Resolution set to worksforme
Note: See TracTickets for help on using tickets.