Page History

/etc/my.cnf 
[mysqld]
character-set-server=utf8 
collation-server=utf8_general_ci


auto-increment-increment = 100
auto-increment-offset = 1# Connection and Thread variables
port                           = 3306
socket                         = /var/run/mysqld/mysql.sock          # Use mysqld.sock on Ubuntu, conflicts with AppArmor otherwise
basedir                        = /usr
datadir                        = /data/mysql
tmpdir                         = /tmp
character_set_server           = utf8
collation_server               = utf8_general_ci


# dir set
chown -R mysql:mysql /data/mysql