[MacPorts] #26749: mysql5 installation cant put password

[MacPorts]

#26749: mysql5 installation cant put password
---------------------------------------------+------------------------------
 Reporter:  erchache2000.macports@…          |       Owner:  macports-tickets@…                   
     Type:  defect                           |      Status:  new                                  
 Priority:  High                             |   Milestone:                                       
Component:  ports                            |     Version:  1.9.1                                
 Keywords:                                   |        Port:                                       
---------------------------------------------+------------------------------
 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?

-- 
Ticket URL: <https://trac.macports.org/ticket/26749>
MacPorts <http://www.macports.org/>
Ports system for Mac OS