Install MySQL on AlmaLinux 9

Step 1 – Install and secure

dnf install epel-release -y
dnf install -y mysql-server
systemctl enable --now mysqld
mysql_secure_installation

Step 2 – Connect

mysql -u root -p

Step 3 – Create database and user

CREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE...

Install MySQL on Arch Linux

Step 1 – Install and secure

pacman -S --noconfirm mysql
mysqld --initialize --user=mysql
systemctl enable --now mysqld
mysql_secure_installation

Step 2 – Connect

mysql -u root -p

Step 3 – Create database and user

CREATE DATABASE appdb CHARACTER SET utf8mb4 COL...

Install MySQL on Debian 12

Step 1 – Install and secure

apt update && apt upgrade -y
apt install -y mysql-server
systemctl enable --now mysql
mysql_secure_installation

Step 2 – Connect

mysql -u root -p

Step 3 – Create database and user

CREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE u...

Install MySQL on Gentoo Linux

Step 1 – Install and secure

emerge --ask dev-db/mysql
emerge --config dev-db/mysql
rc-update add mysql default && rc-service mysql start
mysql_secure_installation

Step 2 – Connect

mysql -u root -p

Step 3 – Create database and user

CREATE DATABASE appdb CHARA...

Install MySQL on NetBSD 10

Step 1 – Install and secure

pkgin install mysql80-server
/usr/pkg/bin/mysqld --initialize --user=mysql
echo 'mysqld=YES' >> /etc/rc.conf && service mysqld start
mysql_secure_installation

Step 2 – Connect

mysql -u root -p

Step 3 – Create database and user

CREATE...

Install MySQL on OpenBSD 7.5

Step 1 – Install and secure

pkg_add mariadb-server
mysql_install_db
rcctl enable mysqld && rcctl start mysqld
mysql_secure_installation

Step 2 – Connect

mysql -u root -p

Step 3 – Create database and user

CREATE DATABASE appdb CHARACTER SET utf8mb4 COLLATE utf...

Install MySQL on RHEL 9

Step 1 – Install and secure

subscription-manager repos --enable codeready-builder-for-rhel-9-$(arch)-rpms
dnf install -y mysql-server
systemctl enable --now mysqld
mysql_secure_installation

Step 2 – Connect

mysql -u root -p

Step 3 – Create database and user

CREATE...

Install MySQL on Ubuntu 24.04

Step 1 – Install and secure

apt update && apt upgrade -y
apt install -y mysql-server
systemctl enable --now mysql
mysql_secure_installation

Step 2 – Connect

mysql -u root -p

Step 3 – Create database and user

CREATE DATABASE appdb CHARACTER SET utf8mb4 COLLAT...

Start by installing nginx

apt install nginx-full

Nginx virtualhost setup

vi /etc/nginx/sites-available/yourowndomain

server {
                server_name     CHANGE_THIS_with_YOUROWNDOMAIN;
                client_max_body_size 50M;

                location / {
                proxy_pass htt...

Start by installing nginx

apt install nginx-full

Nginx virtualhost setup

vi /etc/nginx/sites-available/yourowndomain

server {
                server_name     CHANGE_THIS_with_YOUROWNDOMAIN;
                client_max_body_size 50M;

                location / {
                proxy_pass htt...

Start by installing nginx

apt install nginx-full

Nginx virtualhost setup

vi /etc/nginx/sites-available/yourowndomain

server {
                server_name     CHANGE_THIS_with_YOUROWNDOMAIN;
                client_max_body_size 50M;

                location / {
                proxy_pass htt...

Mysql 8 has different method resetting pw then mysql 5. First is needed to set empty auth string

In Linux:

Stop mysqld

service mysqld stop

Start MySQL with skip grant tables

mysqld --skip-grant-tables --skip-networking --user=mysql &

Set authentication empty string

login

mysql -u ro...

MySQL Backup and Restore on AlmaLinux 9

mysqldump

# Single database
mysqldump -u root -p appdb > /backups/appdb_$(date +%F).sql

# All databases
mysqldump -u root -p --all-databases > /backups/all_$(date +%F).sql

# Compressed
mysqldump -u root -p appdb | gzip > /backups/appdb_$(date +%F).sql.gz...

MySQL Backup and Restore on Arch Linux

mysqldump

# Single database
mysqldump -u root -p appdb > /backups/appdb_$(date +%F).sql

# All databases
mysqldump -u root -p --all-databases > /backups/all_$(date +%F).sql

# Compressed
mysqldump -u root -p appdb | gzip > /backups/appdb_$(date +%F).sql.gz

MySQL Backup and Restore on Debian 12

mysqldump

# Single database
mysqldump -u root -p appdb > /backups/appdb_$(date +%F).sql

# All databases
mysqldump -u root -p --all-databases > /backups/all_$(date +%F).sql

# Compressed
mysqldump -u root -p appdb | gzip > /backups/appdb_$(date +%F).sql.gz

MySQL Backup and Restore on Gentoo Linux

mysqldump

# Single database
mysqldump -u root -p appdb > /backups/appdb_$(date +%F).sql

# All databases
mysqldump -u root -p --all-databases > /backups/all_$(date +%F).sql

# Compressed
mysqldump -u root -p appdb | gzip > /backups/appdb_$(date +%F).sql.g...

MySQL Backup and Restore on NetBSD 10

mysqldump

# Single database
mysqldump -u root -p appdb > /backups/appdb_$(date +%F).sql

# All databases
mysqldump -u root -p --all-databases > /backups/all_$(date +%F).sql

# Compressed
mysqldump -u root -p appdb | gzip > /backups/appdb_$(date +%F).sql.gz

MySQL Backup and Restore on OpenBSD 7.5

mysqldump

# Single database
mysqldump -u root -p appdb > /backups/appdb_$(date +%F).sql

# All databases
mysqldump -u root -p --all-databases > /backups/all_$(date +%F).sql

# Compressed
mysqldump -u root -p appdb | gzip > /backups/appdb_$(date +%F).sql.gz...

MySQL Backup and Restore on RHEL 9

mysqldump

# Single database
mysqldump -u root -p appdb > /backups/appdb_$(date +%F).sql

# All databases
mysqldump -u root -p --all-databases > /backups/all_$(date +%F).sql

# Compressed
mysqldump -u root -p appdb | gzip > /backups/appdb_$(date +%F).sql.gz

Re

MySQL Backup and Restore on Ubuntu 24.04

mysqldump

# Single database
mysqldump -u root -p appdb > /backups/appdb_$(date +%F).sql

# All databases
mysqldump -u root -p --all-databases > /backups/all_$(date +%F).sql

# Compressed
mysqldump -u root -p appdb | gzip > /backups/appdb_$(date +%F).sql.g...

MySQL Primary-Replica Replication on AlmaLinux 9

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH...

MySQL Primary-Replica Replication on Arch Linux

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH m...

MySQL Primary-Replica Replication on Debian 12

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH my...

MySQL Primary-Replica Replication on Gentoo Linux

Primary: 192.168.1.10   Replica: 192.168.1.11

Primary – my.cnf

[mysqld]
server-id   = 1
log_bin     = /var/log/mysql/mysql-bin
binlog_format = ROW
binlog_expire_logs_seconds = 604800

CREATE USER 'replicator'@'192.168.1.11' IDENTIFIED WITH...