[MacPorts] #39179: mysql55-server root set password failure

[MacPorts]

#39179: mysql55-server root set password failure
--------------------------------------------+------------------------------
 Reporter:  vit9696@…                       |      Owner:  macports-
     Type:  defect                          |  tickets@…
 Priority:  Normal                          |     Status:  new
Component:  ports                           |  Milestone:
 Keywords:  mysql, mysql55, mysql55-server  |    Version:  2.1.3
                                            |       Port:  mysql55-server
--------------------------------------------+------------------------------
 Hello, I am experiencing rather strange problem with mysql55-server which
 I installed on Mac OS X 10.6.8.

 I followed this guide http://trac.macports.org/wiki/howto/MAMP#mysql but
 installed mysql55-server. After that, I successfully set chmods (had to
 change mysql5 directory to mysql55 though) and ran sudo -u _mysql
 /opt/local/lib/mysql55/bin/mysql_install_db with no errors:
 Installing MySQL system tables...
 OK
 Filling help tables...
 OK

 To start mysqld at boot time you have to copy
 support-files/mysql.server to the right place for your system

 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
 To do so, start the server, then issue the following commands:

 /opt/local/lib/mysql55/bin/mysqladmin -u root password 'new-password'
 /opt/local/lib/mysql55/bin/mysqladmin -u root -h admin-pc password 'new-
 password'

 Alternatively you can run:
 /opt/local/lib/mysql55/bin/mysql_secure_installation

 which will also give you the option of removing the test
 databases and anonymous user created by default.  This is
 strongly recommended for production servers.

 See the manual for more instructions.

 You can start the MySQL daemon with:
 cd /opt/local ; /opt/local/lib/mysql55/bin/mysqld_safe &

 You can test the MySQL daemon with mysql-test-run.pl
 cd /opt/local/mysql-test ; perl mysql-test-run.pl

 Please report any problems with the /opt/local/lib/mysql55/bin/mysqlbug
 script!

 after I loaded mysql (sudo port load mysql55-server) and saw mysqld
 process with _mysql owner in Task Manager I tired:
 /opt/local/lib/mysql55/bin/mysqladmin -u root -h admin-pc password
 MY_PASSWORD
 but got:
 mysqladmin: Could not determine old_passwords setting from server; error:
 'Lost connection to MySQL server during query'
 In that case I decided to use secure installation mode:
 admin-pc:mysql55 vit9696$ sudo -u _mysql
 /opt/local/lib/mysql55/bin/mysql_secure_installation


 NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
       SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!


 In order to log into MySQL to secure it, we'll need the current
 password for the root user.  If you've just installed MySQL, and
 you haven't set the root password yet, the password will be blank,
 so you should just press enter here.

 Enter current password for root (enter for none):
 OK, successfully used password, moving on...

 Setting the root password ensures that nobody can log into the MySQL
 root user without the proper authorisation.

 Set root password? [Y/n] Y
 New password:
 Re-enter new password:
 ERROR 2006 (HY000) at line 1: MySQL server has gone away
 Password update failed!
 Cleaning up...

 After that I tried to set big wait_timeout and max_allowed_packet values
 in my.cnf... But that didn't work (after port relaunch of course). I tried
 to clean the port and fully reinstalled it two times and now I am
 completely at a loss what to do. Could you help me?

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