CentOS7安装MariaDB 10.5.4

安装依赖

yum install -y git gcc gcc-c++ cmake libaio libaio-devel bison bison-devel zlib-devel ncurses ncurses-devel perl pcre-devel libxml2-devel libevent-devel rpm-build openssl-devel boost-program-options lsof socat perl-Compress-Raw-Bzip2 perl-Compress-Raw-Zlib perl-DBI perl-Data-Dumper perl-IO-Compress perl-Net-Daemon perl-PlRPC pcre2

目录、权限配置

groupadd mysql
useradd mysql -g mysql

mkdir -p /usr/local/mysql
mkdir -p /usr/local/db/mysql/data
mkdir -p /auth_pam_tool_dir
touch /auth_pam_tool_dir/auth_pam_tool

chown -R mysql:mysql /usr/local/mysql
chown -R mysql:mysql /usr/local/db/mysql/data
chown -R mysql:mysql /usr/local/mysql/.
chown -R mysql:mysql /usr/local/db/mysql/data/.
chown -R mysql:mysql /auth_pam_tool_dir

echo "PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH" >> /etc/profile
echo "export PATH" >> /etc/profile

source /etc/profile

安装前将CentOS7自带的MariaDB删掉

rpm -qa | grep mariadb    #查出系统自带的MariaDB版本号

rpm -e --nodeps mariadb-libs-5.5.65-1.el7.x86_64

删除了CentOS7自带的MariaDB后，my.cnf也会同时被删除，手工上加my.cnf

vi /etc/my.cnf

[client]
port = 22066
socket = /usr/local/mysql/mysqld.sock

# The MySQL server
[mysqld]
port = 22066
socket = /usr/local/mysql/mysqld.sock
datadir = /usr/local/db/mysql/data
skip-external-locking
skip-name-resolve
back_log = 50
max_connections = 2048
max_connect_errors = 1000
table_open_cache = 1024
open_files_limit = 16384
max_allowed_packet = 16M
read_buffer_size = 8M
read_rnd_buffer_size = 32M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 64
query_cache_size = 64M
query_cache_limit = 4M
slow_query_log = 1
long_query_time = 2
lower_case_table_names = 1
innodb_file_per_table = 1
max_allowed_packet = 1G
server-id = 1
log-bin = mysql-bin
expire_logs_days = 7
binlog_format = ROW

innodb_data_file_path = ibdata1:12M:autoextend
innodb_buffer_pool_size = 2G
innodb_write_io_threads = 12
innodb_read_io_threads = 8
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 16M
innodb_log_file_size = 170M
innodb_lock_wait_timeout = 60

开始安装，将mariadb-10.5.4.tar.gz放到/usr/local下

tar zxvf mariadb-10.5.4.tar.gz
cd mariadb-10.5.4

cmake -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/usr/local/db/mysql/data -DMYSQL_USER=mysql -DMYSQL_TCP_PORT=22066

make -j4
make install

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/db/mysql/data

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

service mysql start

chkconfig mysql on

mysqladmin -u root password '123456'

mysql -uroot -p123456

GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123456";
flush privileges;