sudo rm -rf /etc/mysql
sudo apt remove -y mysql-common
sudo apt autoremove -y
sudo apt install -y cmake libncurses5-dev libgnutls28-dev
sudo groupadd -r mysql && sudo useradd -r -g mysql -s /sbin/nologin -d /usr/local/mariadb mysql
sudo mkdir -p /data/db /var/log/mariadb
cd /home/allen/下载/mariadb-10.5.4/
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mariadb -DMYSQL_DATADIR=/data/db -DSYSCONFDIR=/etc -DWITHOUT_TOKUDB=1 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci
make -j 4 && sudo make install
sudo /usr/local/mariadb/scripts/mysql_install_db --user=mysql --datadir=/data/db
sudo vim /etc/my.cnf
[mysqld]
datadir = /data/db
socket = /tmp/mysql.sock
symbolic-links = 0
collation-server = utf8mb4_general_ci
init-connect = 'SET NAMES utf8mb4'
character-set-server = utf8mb4
[mysql]
default-character-set = utf8mb4
[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8mb4
[mysqld_safe]
log-error = /var/log/mariadb/mariadb.log
pid-file = /var/run/mariadb/mariadb.pid
sudo cp /usr/local/mariadb/support-files/mysql.server /etc/init.d/mariadb
sudo vim /etc/profile.d/mariadb.sh
export PATH=$PATH:/usr/local/mariadb/bin/
sudo chmod 0777 /etc/profile.d/mariadb.sh
source /etc/profile.d/mariadb.sh
sudo /etc/init.d/mariadb start
sudo /usr/local/mariadb/bin/mysql_secure_installation
sudo systemctl enable mariadb
sudo chown mysql:mysql -R /usr/local/mariadb /data/db /var/log/mariadb
reboot