Re: Note for mysql55-server

[Takahiro Kambe <taca%back-street.net@localhost>]

One correction.

In message <20110501.233636.680961628036329555.taca%back-street.net@localhost>
        on Sun, 01 May 2011 23:36:36 +0900 (JST),
        Takahiro Kambe <taca%back-street.net@localhost> wrote:
> workaround:
>       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."
        else
                echo "Initializing MySQL database system tables."
-               ${initdb} --force --user=${mysqld_user} \
+               ${initdb} --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} \


-- 
Takahiro Kambe <taca%back-street.net@localhost>