Search notes:

MariaDB

sudo apt-get install mariadb-server mariadb-client

Scripts, utilities etc

mysqld_safe: the recommended script to start mysqld

mysqladmin: adminstering mysqld: used to monitor sessions, show statistics, create and drop databases, flush logs, kill queries, stop the server etc.

Configuration files

Default options from the first file found in the following list (seems to be subject to changes over time)

/etc/mysql/mariadb.cnf (might be symlinked from /etc/my.cnf)
/etc/mysql/my.cnf
my.cnf in DEFAULT_SYSCONFDIR (which is a compile option)
my.cnf in $MYSQL_HOME
file specified with --defaults-extra-file
~/my.cnf

Charactersets

Default ist latin 1. In order to use UTF-8, add

default-character-set = utf8mb4

to the [client] and [server] section in one of the configuration files

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788510525, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/MariaDB/index(62): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

MariaDB

Scripts, utilities etc

Configuration files

Charactersets

See also