.my.cnf

# Example mysql config file.
# You can copy this to one of:
# /etc/my.cnf to set global options,
# /mysql-data-dir/my.cnf to get server specific options or
# ~/my.cnf for user specific options.
# 
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options

# This will be passed to all mysql clients
[client]
password=Donna...43Summer
#port=3306
#socket=/tmp/mysql.sock
default-character-set=utf8

# Here is entries for some specific programs
# The following values assume you have at least 32M ram

# The MySQL server
[mysqld]
#port=3306
#socket=/tmp/mysql.sock
temp-pool
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

# The following three entries caused mysqld 10.0.1-MariaDB (and possibly other versions) to abort...
# skip-locking
# set-variable  = key_buffer=16M
# set-variable  = thread_cache=4

loose-innodb_data_file_path = ibdata1:1000M
loose-mutex-deadlock-detector
gdb

######### Fix the two following paths

# Where you want to have your database
data=~/.mysql.database

# Where you have your mysql/MariaDB source + sql/share/english
language=/usr/share/mariadb/english

[mysqldump]
quick
set-variable = max_allowed_packet=16M

[mysql]
no-auto-rehash
default-character-set=utf8

[myisamchk]
set-variable= key_buffer=128M