tech-pkg archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

Note for mysql55-server


Here is two problem with mysql55-server pacakge.  I write them here
simply for memo.  I don't think it is pkgsrc specific problems.

1. server failed to start. 

log message contains:

        COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8'

I don't know where came from 'latin1_swedish_ci'.

        Add "--collation-server=utf8_general_ci" to mysql_install_db's
        parameter and mysqld_flags in /etc/rc.conf.

--- /usr/pkg/share/examples/rc.d/mysqld 2011-04-27 16:42:29.000000000 +0900
+++ /etc/rc.d/mysqld    2011-04-29 18:31:28.000000000 +0900
@@ -51,7 +51,8 @@
                echo "Skipping database initialization."
                echo "Initializing MySQL database system tables."
-               ${initdb} --force --user=${mysqld_user} \
+               ${initdb} --user=mysql --collation-server=utf8_general_ci \
+                         --force --user=${mysqld_user} \
                          --datadir=${mysqld_datadir} || return 1
                if [ -d ${mysqld_datadir} ]; then
                        /usr/sbin/chown -R ${mysqld_user}:${mysqld_group} \

2. mysqld listen only [::1]:3306.

mysqld might believe that IPv4/IPv6 can accept one socket.  I don't
have right solution.

        Add "--bind-address=" to mysqld_flags in /etc/rc.conf.

So, now I have /etc/rc.conf:

mysqld_flags="--bind-address= --collation-server=utf8_general_ci"

I wish other people wouldn't suffer these problems.

Takahiro Kambe <>

Home | Main Index | Thread Index | Old Index