mariadb

Install in AMI 2023

dnf install mariadb105-server.x86_64 -y

systemctl start mariadb
systemctl enable mariadb

find / -name mariadb-secure*

/usr/bin/mariadb-secure-installation

Change character set

vi /etc/my.cnf.d/mariadb-server.cnf

[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci

systemctl restart mariadb

Connect

mysql --host trainingdiarydb.czw4c0kgeode.ap-northeast-2.rds.amazonaws.com --port 3306 -u admin -p

show databases;
use trainingdiary;
show tables;

Check character set and collation in mysql client

show variables where variable_name like 'c%';

mysqldump

mysqldump -u username -p database_name > data-dump.sql
head data-dump.sql

mysql -u username -p new_database < data-dump.sql