mysql56: check failed: 'field[1].type == MYSQL_TYPE_BLOB'

[ora.et.labora@…]

$ mysql_client_test -p
[..]
#####################################
196 of (1/1): test_bug14169  
#####################################
GROUP_CONCAT() result type 253/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_ports_databases_mysql56/mysql56/work/mysql-5.6.19/tests/mysql_client_test.c:15409: check failed: 'field[1].type == MYSQL_TYPE_BLOB'


$ type -a mysql_client_test 
mysql_client_test is /opt/local/bin/mysql_client_test

$ mysql_client_test --help

mysql_client_test  Ver 2.1 Distrib 5.6.19, for osx10.8 (x86_64)
By Monty, Venu, Kent and others
[..]

$ mysql --version
mysql  Ver 14.14 Distrib 5.6.19, for osx10.8 (x86_64) using  EditLine wrapper
root@lhasa:~
$ type -a mysql
mysql is /opt/local/bin/mysql

What I did:
I upgraded from mysql5 to 5.6 by doing:

$ /opt/local/lib/mysql5/bin/mysqldump --all-databases -p > mysql5dump.out

# remove mysql5 et cetera

$ sudo port install mysql56
$ sudo port install mysql56-server
$ sudo port select --set mysql mysql56
$ mysql_upgrade -p
$ sudo mysqld --user mysql # in other terminal (just for the record)
$ mysql_upgrade -p

Personal note:
MySQL and -- I'm afraid to say Mariadb as well -- are the source of never ending trouble.

[ora.et.labora@…]

Sorry, forgot to format code in "what I did section" .. how can I change after having submitted?

[pixilla (Bradley Giesbrecht)]

This looks like a MySQL issue, is there something MacPorts is doing that you believe is the cause?

Were there issues loading mysql5dump.out into mysql56?

[pixilla (Bradley Giesbrecht)]

All the MacPorts mysql database ports by default use different a "datadir". Did you create the mysql56 datadir by running the mysql_install_db script as the mysql56-server notes suggest?

port notes mysql56-server

These steps should get you a functional mysql56 server:

$ sudo port install mysql56-server
$ sudo -u _mysql /opt/local/lib/mysql56/bin/mysql_install_db
$ sudo port load mysql56-server
$ /opt/local/lib/mysql56/bin/mysql
mysql> show databases;
mysql> quit;

[murrayeisenberg@…]

During second of above-recommended installation steps...

$ sudo port install mysql56-server
$ sudo -u _mysql /opt/local/lib/mysql56/bin/mysql_install_db

...get:

WARNING: Could not write to config file /opt/local/etc/mysql56/my-new.cnf: Permission denied

And then when the mysql_install_db command completes:

WARNING: Could not copy config file template /opt/local/share/mysql56/support-files/my-default.cnf to
/opt/local/etc/mysql56/my-new.cnf, may not have access rights to do so.

So is there some missing step one needs to do to change permissions?

[mf2k (Frank Schima)]

See #57827