Identity

Unit: mariadb.service (Debian/Ubuntu) or mysqld.service (RHEL/Fedora)
Config: /etc/mysql/my.cnf, /etc/mysql/mariadb.conf.d/ (Debian/Ubuntu); /etc/my.cnf, /etc/my.cnf.d/ (RHEL/Fedora)
Data dir: /var/lib/mysql/
Socket: /run/mysqld/mysqld.sock (Debian/Ubuntu), /var/lib/mysql/mysql.sock (RHEL)
Error log: /var/log/mysql/error.log (Debian/Ubuntu), /var/log/mariadb/mariadb.log (RHEL)
Slow query log: /var/log/mysql/mysql-slow.log (when enabled)
Distro install: apt install mariadb-server / dnf install mariadb-server
Post-install security: sudo mysql_secure_installation

Key Operations

Operation	Command
Service status	`sudo systemctl status mariadb`
Connect as root (socket auth)	`sudo mariadb`
Connect with password	`mysql -u root -p` or `mysql -u myuser -p mydb`
Connect to remote host	`mysql -h 10.0.0.5 -u myuser -p mydb`
List databases	`SHOW DATABASES;`