Setting up a self-hosted mysql instance

[moll-re]

• Install mariadb-server from apt.
• Edit /etc/mysql/my.cnf to allow external access (set running ip to 0.0.0.0): Actually directly overwrite the parameter in /etc/mysql/mariadb.conf.d/50-server.cnf
• Restart mariadb through systemctl.
• Run the secure installation: sudo mysql_secure_installation
• Now we go into SQL and apply a few changes: (sudo mysql)
  • Create new db: CREATE DATABASE aio_logging;
  • Create new user: CREATE USER 'aio_logger'@'localhost' IDENTIFIED BY 'password';
  • Grant all necessary privileges: GRANT ALL ON aio_logging.* to 'aio_logger'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
  • EDIT: for django we need to set the timezones: mysql_tzinfo_to_sql /usr/share/zoneinfo | sudo mysql -u root -p mysql
  • Apply: FLUSH PRIVILEGES;
• For python remote control, I use peewee with pymysql as a driver.

[moll-re]

For django, set the backend to django.db.backends.mysql and install mysqlclient through pip. This also requires system-packages:

sudo apt-get install python3-dev default-libmysqlclient-dev build-essential

EDIT: for arch-linux the package is: mariadb-libs

[moll-re]

Aditionally: enable emoji support and utf8 in general: Is a client issue. TODO: change in django and peewee!