ubuntu 安裝 MariaDB 資料庫 - 22.04

 安裝 MariaDB 資料庫

$ sudo apt install mariadb-server

檢視 MariaDB 執行狀態，要停用改用 stop、啟動使用 start、重啟 restart

$ sudo systemctl status mariadb

主要設定檔為 /etc/mysql/my.cnf、 /etc/mysql/mariadb.conf.d/50-server.cnf

$ sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf

若要自訂資料庫相關參數，可以不要修改原本預設的設定檔，可以在  /etc/mysql/mariadb.conf.d/ 目錄下新增 z 開頭的設定檔，載入參數時最後將以這個檔案進行參數覆蓋

例如新增 z-mariadb.cnf，然後裡面新增類似 max_connections = 100、innodb_buffer_pool_size = 512M 的參數指定

 資料庫初始化 mysql_secure_installation

$ sudo mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user. If you've just installed MariaDB, and
haven't set the root password yet, you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password or using the unix_socket ensures that nobody
can log into the MariaDB root user without the proper authorisation.

You already have your root account protected, so you can safely answer 'n'.

Switch to unix_socket authentication [Y/n]
Enabled successfully!
Reloading privilege tables..
 ... Success!

You already have your root account protected, so you can safely answer 'n'.

Change the root password? [Y/n] y
New password: 輸入 root 密碼
Re-enter new password: 輸入 root 密碼
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

登入資料庫，這個時候就需要前面所設定的 root 密碼了

 $ mysql -u root -p

 新增資料庫 zabbix

MariaDB [(none)]> create database zabbix;

新增一個 MariaDB/MySQL 資料庫使用者 zabbix，並將密碼設定為 passwordx

MariaDB [(none)]> CREATE USER 'zabbix'@'localhost' IDENTIFIED BY 'passwordx';

授予 zabbix 擁有 zabbix 資料庫所有權限

套用權限

MariaDB [(none)]> FLUSH PRIVILEGES;

Reference：

• 在 Ubuntu 22.04 安裝 MariaDB 資料庫 https://blog.tarswork.com/post/mariadb-install-record  
•