# 查看数据库状态 > sudo systemctl status mariadb ● mariadb.service - MariaDB 10.11.6 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; preset: enabled) Active: active (running) since Fri 2024-03-01 13:39:41 CST; 7h ago Docs: man:mariadbd(8) https://mariadb.com/kb/en/library/systemd/ Main PID: 39845 (mariadbd) Status: "Taking your SQL requests now..." Tasks: 8 (limit: 2153) Memory: 212.8M CPU: 2.940s CGroup: /system.slice/mariadb.service └─39845 /usr/sbin/mariadbd
设置数据库开机启动
1
sudo systemctl enable mariadb
初始化数据库
1
sudo mysql_secure_installation
注意这里root不需要远程登录权限, 远程登录的管理用户单独创建。
修改数据库配置允许远程连接以及端口号
1 2 3 4 5 6
vim /etc/mysql/mariadb.conf.d/50-server.cnf 修改 bind-address = 0.0.0.0
[mysqld] port = 3336 sudo systemctl restart mariadb
创建对应的帐号
1 2 3 4 5 6 7 8 9
DROP USER IF EXISTS 'acore'@'localhost'; CREATE USER 'acore'@'localhost' IDENTIFIED BY 'acore' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0; GRANT ALL PRIVILEGES ON * . * TO 'acore'@'localhost' WITH GRANT OPTION; CREATE DATABASE `acore_world` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci; CREATE DATABASE `acore_characters` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci; CREATE DATABASE `acore_auth` DEFAULT CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci; GRANT ALL PRIVILEGES ON `acore_world` . * TO 'acore'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON `acore_characters` . * TO 'acore'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON `acore_auth` . * TO 'acore'@'localhost' WITH GRANT OPTION;
创建一个远程连接的帐号用于管理
1 2 3 4
CREATE USER 'gm'@'%' IDENTIFIED BY 'mima' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0; GRANT ALL PRIVILEGES ON `acore_world`. * TO 'gm'@'%' ; GRANT ALL PRIVILEGES ON `acore_characters`. * TO 'gm'@'%' ; GRANT ALL PRIVILEGES ON `acore_auth`. * TO 'gm'@'%' ;