Opened 6 years ago

Closed 6 years ago

#26749 closed defect (worksforme)

mysql5 installation cant put password

Reported by: erchache2000.macports@… Owned by: ryandesign (Ryan Schmidt)
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 (3)

comment:1 Changed 6 years ago by jmroot (Joshua Root)

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

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 6 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 6 years ago by ryandesign (Ryan Schmidt)

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