mysql55-server root set password failure

[vit9696]

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?

[mf2k (Frank Schima)]

In the future, please use WikiFormatting.

Trac is not for tech support. Instead use the ​Macports Users Mailing List.

[vit9696]

In the future, please use WikiFormatting.

Hmm, ok.

Trac is not for tech support. Instead use the ​Macports Users Mailing List.

I know, but that looks like a bug, doesn't it? Sorry for writing the ticket in that manner. (If you consider this being another case, please, just close a ticket)

[mf2k (Frank Schima)]

Cc'ing maintainer who can make that assessment.