建立使用環境

1. 遠端登入 kvm3.deyu.wang 虛擬機。

   [root@deyu ~]# ssh root@kvm3.deyu.wang
   root@kvm3.deyu.wang's password: 
   Last login: Mon Oct 13 17:23:54 2025 from 192.168.122.1
   [root@kvm3 ~]#
   

2. 安裝 mariadb-server。

   [root@kvm3 ~]# dnf install mariadb-server
   

3. 設定開機自動啟動 mariadb 服務，且馬上啟動。

   [root@kvm3 ~]# systemctl enable --now mariadb.service 
   Created symlink /etc/systemd/system/mysql.service →
    /usr/lib/systemd/system/mariadb.service.
   Created symlink /etc/systemd/system/mysqld.service →
    /usr/lib/systemd/system/mariadb.service.
   Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service →
    /usr/lib/systemd/system/mariadb.service.
   

4. 查看 mariadb 服務狀態，啟動成功，沒有警告訊息。

   [root@kvm3 ~]# systemctl status mariadb
   ○ mariadb.service - MariaDB 10.11 database server
        Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: >
        Active: inactive (dead) since Mon 2025-10-13 17:32:30 CST; 31min ago
      Duration: 4min 1.061s
    Invocation: 765ced14265f4da59f6aef71997161f6
          Docs: man:mariadbd(8)
                https://mariadb.com/kb/en/library/systemd/
       Process: 2262 ExecStartPre=/usr/libexec/mariadb-check-socket (code=exited, >
       Process: 2286 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir mariadb.serv>
       Process: 2322 ExecStart=/usr/libexec/mariadbd --basedir=/usr $MYSQLD_OPTS $>
       Process: 2335 ExecStartPost=/usr/libexec/mariadb-check-upgrade (code=exited>
      Main PID: 2322 (code=exited, status=0/SUCCESS)
        Status: "MariaDB server is down"
      Mem peak: 202.2M
           CPU: 543ms
   
   Oct 13 17:28:28 kvm3.deyu.wang systemd[1]: Starting mariadb.service - MariaDB 1>
   Oct 13 17:28:28 kvm3.deyu.wang mariadb-prepare-db-dir[2286]: Database MariaDB i>
   Oct 13 17:28:28 kvm3.deyu.wang mariadb-prepare-db-dir[2286]: If this is not the>
   Oct 13 17:28:28 kvm3.deyu.wang (mariadbd)[2322]: mariadb.service: Referenced bu>
   Oct 13 17:28:28 kvm3.deyu.wang systemd[1]: Started mariadb.service - MariaDB 10>
   Oct 13 17:32:29 kvm3.deyu.wang systemd[1]: Stopping mariadb.service - MariaDB 1>
   Oct 13 17:32:30 kvm3.deyu.wang systemd[1]: mariadb.service: Deactivated success>
   Oct 13 17:32:30 kvm3.deyu.wang systemd[1]: Stopped mariadb.service - MariaDB 10>
   Oct 13 17:32:30 kvm3.deyu.wang systemd[1]: mariadb.service: Consumed 543ms CPU >
   

5. 查看 mariadb 版本。

   [root@kvm3 ~]# mysqladmin -V
   mysqladmin  Ver 10.0 Distrib 10.11.11-MariaDB, for Linux on x86_64
   

6. 查看 mariadb port 為 3306。

   [root@kvm3 ~]# ss -tlnp | grep mariadb
   LISTEN 0      80           0.0.0.0:3306      0.0.0.0:*    users:(("mariadbd",pid=2847,fd=19))
   LISTEN 0      80              [::]:3306         [::]:*    users:(("mariadbd",pid=2847,fd=21))