下載安裝包
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
移動(dòng)至/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
設(shè)置權(quán)限
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
設(shè)置環(huán)境變量
echo 'export PATH=$PATH:/opt/mariadb/bin' > /etc/profile.d/mariadb.sh
source /etc/profile
初始化數(shù)據(jù)庫
/opt/mariadb/scripts/mariadb-install-db
設(shè)置服務(wù)
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
啟動(dòng)服務(wù)
systemctl enable mariadb --now
systemctl status mariadb
登錄
mysql -uroot -p
如果報(bào)錯(cuò)mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
yum install libncurses* -y
設(shè)置密碼
alter user "root"@"localhost" identified by "YOUR_PASSWORD";
flush privileges;
