MariaDB導入

1．MariaDBインストール

[root@miracle ~]# dnf -y install mariadb-server

2．php-mysqlndインストール

[root@miracle ~]# dnf -y install php-mysqlnd

3．MariaDB設定

mariadb-server.cnf 設定ファイル編集

[root@miracle ~]# vi /etc/my.cnf.d/mariadb-server.cnf
[mysqld]
character-set-server = utf8mb4　←　追加

client.cnf 設定ファイル編集

[root@miracle ~]# vi /etc/my.cnf.d/client.cnf
[client]
default-character-set = utf8mb4　←　追加

mysql-clients.cnf 設定ファイル編集

[root@miracle ~]# vi /etc/my.cnf.d/mysql-clients.cnf
[mysql]
default-character-set = utf8mb4　←　追加

[mysqldump]
default-character-set = utf8mb4　←　追加

4．MariaDB起動

[root@miracle ~]# systemctl start mariadb

5．MariaDB自動起動設定

[root@miracle ~]# systemctl enable mariadb

6．MariaDBステータス確認

[root@miracle ~]# systemctl status mariadb　
● mariadb.service - MariaDB 10.3 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor p>
   Active: active (running) since Thu 2022-09-15 00:13:45 EDT; 13s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
 Main PID: 4486 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 30 (limit: 11352)
   Memory: 74.5M
   CGroup: /system.slice/mariadb.service
           └─4486 /usr/libexec/mysqld --basedir=/usr

 9月 15 00:13:40 miracle systemd[1]: Starting MariaDB 10.3 database server...
 9月 15 00:13:41 miracle mysql-prepare-db-dir[4382]: Initializing MariaDB dat>
 9月 15 00:13:45 miracle mysqld[4486]: 2022-09-15  0:13:45 0 [Note] /usr/libe>
 9月 15 00:13:45 miracle systemd[1]: Started MariaDB 10.3 database server.

7．MariaDB初期設定

[root@miracle ~]# mysql_secure_installation
Enter current password for root (enter for none): 　←　空ENTER
OK, successfully used password, moving on...

Set root password? [Y/n] 　←　空ENTER
New password: 　←　rootパスワード
Re-enter new password: 　←　rootパスワード
Password updated successfully!

Remove anonymous users? [Y/n] 　←　空ENTER(匿名ユーザー削除)
 ... Success!

Disallow root login remotely? [Y/n] 　←　空ENTER(リモートからのrootログイン禁止)
 ... Success!

Remove test database and access to it? [Y/n] 　←　空ENTER(testデータベース削除)
 - Dropping test database...
 ... Success!

Reload privilege tables now? [Y/n] 　←　空ENTER
 ... Success!

Thanks for using MariaDB!