MariaDB 在 FreeNAS Jail 中的安裝

FreeNAS 11.x Jail 中的 MariaDB Binary 有相容性問題, 導致 MariaDB Server 無法正確啟動.
solution ref link : https://forums.freenas.org/index.php?threads/fdatasync.59650/

Build / Install Instruction / Step (MariaDB 可能會有更新版本!):
portsnap fetch
portsnap extract && portsnap update
pkg install readline-7.0.3_1 sudo nano tmux mariadb102-server-10.2.15 mariadb102-client-10.2.15
cp /usr/local/share/mysql/my-medium.cnf /usr/local/etc/my.cnf
cd /usr/ports/databases/mariadb102-server
make deinstall
make install clean ALLOW_UNSUPPORTED_SYSTEM=true

Perl Error :
ln -s /usr/local/bin/perl5 /usr/local/bin/perl5.24.4
cd /usr/local

Database Installation (注意! 一定要以 mysql user 來建立 D.B.):
sudo -u mysql mysql_install_db –datadir=/var/db/mysql

Update root Password :
mysqld_safe –skip-grant-tables –datadir=/var/db/mysql

// connecto to server and update user table, host, password.
mysql
UPDATE user SET Password=PASSWORD(‘Input root password here’)

Update Bind Address :
edit : /usr/local/etc/my.cnf
bind-address = 0.0.0.0

Add startup!
sysrc mysql_enable=YES
(/etc/rc.conf, mysql_enable=”YES”)

restart the jail.

GRANT all ON *.* TO root@’localhost’ IDENTIFIED BY ‘Input your root’s passwod’;
FLUSH PRIVILEGES;

Update character set :
[mysqld]
init_connect=’SET collation_connection = utf8_unicode_ci’
init_connect=’SET NAMES utf8′
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake