下载安装包
wget https://mirrors.ustc.edu.cn/mariadb/mariadb-10.6.14/bintar-linux-systemd-x86_64/mariadb-10.6.14-linux-systemd-x86_64.tar.gz
解压
tar xvf mariadb-10.6.14-linux-systemd-x86_64.tar.gz
移动至/opt
mv mariadb-10.6.14-linux-systemd-x86_64 /opt/mariadb
初始化配置文件
echo '!includedir /etc/my.cnf.d' > /etc/my.cnf
mkdir /etc/my.cnf.d
cat <<eof|tee /etc/my.cnf.d/server.cnf
[mysqld]
#base
user=mysql
port=3306
basedir=/opt/mariadb
datadir=/opt/mariadb/data
socket=/opt/mariadb/data/mysql.socket
pid-file=/opt/mariadb/data/mysqld.pid
#log
log_error=/opt/mariadb/log/mariadb.log
slow_query_log=on
slow_launch_time=1
slow_query_log_file=/opt/mariadb/log/mariadb-slow.log
#Optimization
group_concat_max_len=204800
max_connections=500
max_connect_errors=1000
max_allowed_packet=1024M
innodb_buffer_pool_size=1024M
eof
cat <<eof|tee /etc/my.cnf.d/client.cnf
[client]
socket=/opt/mariadb/data/mysql.socket
eof
初始化目录
mkdir /opt/mariadb/data
mkdir /opt/mariadb/log
设置权限
setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=permissive/g' /etc/selinux/config
groupadd mysql
useradd mysql -r -g mysql -s /bin/false
chown -R mysql:mysql /opt/mariadb
设置环境变量
echo 'export PATH=$PATH:/opt/mariadb/bin' > /etc/profile.d/mariadb.sh
source /etc/profile
初始化数据库
/opt/mariadb/scripts/mariadb-install-db
设置服务
cp /opt/mariadb/support-files/systemd/mariadb.service /etc/systemd/system
sed -i \
-e "s|/usr/local/mysql|/opt/mariadb|g" \
-e "/WantedBy=multi-user.target/a Alias=mysql.service" \
/etc/systemd/system/mariadb.service
sed -i "s|/usr/local/mysql|/opt/mariadb|g" /opt/mariadb/bin/galera_recovery
启动服务
systemctl enable mariadb --now
systemctl status mariadb
登录
mysql -uroot -p
如果报错mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
yum install libncurses* -y
设置密码
alter user "root"@"localhost" identified by "YOUR_PASSWORD";
flush privileges;
