MariaDB 設定

1. 登入 mariadb

   [root@kvm11 ~]# mysql -uroot -pxxxxxx
   Welcome to the MariaDB monitor.  Commands end with ; or \g.
   Your MariaDB connection id is 295
   Server version: 10.3.11-MariaDB MariaDB Server
   
   Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   
   MariaDB [(none)]>
   

2. 產生資料庫 dvwadb

   MariaDB [(none)]> create database dvwadb;
   

3. 新增用戶 dvwamgr，對資料庫 dvwadb 擁有所有權限。

   MariaDB [(none)]> grant all on dvwadb.* to dvwamgr@localhost identified by 'xxxxx';
   

4. 重新載入權限表。

   MariaDB [(none)]> flush privileges;
   

5. 退出 mariadb。

   MariaDB [(none)]> quit;
   Bye
   [root@kvm11 ~]#