Rockylinux 安装 MariaDB 作者: Hogwarts 发布于: 2023-07-21 更新于: 2023-07-21 分类: 默认分类 1、引入 MariaDB repo 以及安装 MariaDB wget -qO mariadb_repo_setup.sh https://downloads.mariadb.com/MariaDB/mariadb_repo_setup chmod +x mariadb_repo_setup.sh 2、The current maintained versions are: 10.3, 10.4, 10.5, 10.6, 10.11 (maintained for 5 years), 10.8, 10.9, 10.10, 11.0 (maintained for one year) 当前 MariaDB 的长期支持版本为 10.3, 10.4, 10.5, 10.6, 10.11,选择 10.11 即可。 ./mariadb_repo_setup.sh --mariadb-server-version=mariadb-10.11 3、上述脚本执行完毕后,即引入 MariaDB repo,下面开始安装 MariaDB。 dnf install -y MariaDB-common MariaDB-server MariaDB-client MariaDB-shared MariaDB-backup 4、安装完毕后,编辑 /etc/my.cnf.d/server.cnf,使其默认编码为 utf8mb4 lnum=$(sed -n '/\[mariadb\]/=' /etc/my.cnf.d/server.cnf) sed -i "${lnum}acharacter-set-server = utf8mb4\n\n\[client-mariadb\]\ndefault-character-set = utf8mb4" /etc/my.cnf.d/server.cnf 5、启动 MariaDB systemctl start mariadb systemctl status mariadb systemctl enable mariadb 6、修改用户 root 的密码,删除 test 数据库及不必要的用户名。 db_pass="Thisisdbrootpassword" #这个必须修改 mysql -e "grant all privileges on *.* to root@'127.0.0.1' identified by \"${db_pass}\" with grant option;" mysql -e "grant all privileges on *.* to root@'localhost' identified by \"${db_pass}\" with grant option;" mysql -uroot -p${db_pass} 2>/dev/null < 标签: mariadb, mysql