MySQL安装

yum安装

[root@server ~]# yum info mariadb-server
Repository PowerTools is listed more than once in the configuration
Repository centosplus is listed more than once in the configuration
Available Packages
Name         : mariadb-server
Epoch        : 3
Version      : 10.3.11
Release      : 2.module_el8.0.0+35+6f2527ed
Arch         : x86_64
Size         : 16 M
Source       : mariadb-10.3.11-2.module_el8.0.0+35+6f2527ed.src.rpm
Repo         : AppStream
Summary      : The MariaDB server and related files
URL          : http://mariadb.org
License      : GPLv2 with exceptions and LGPLv2 and BSD.
Description  : MariaDB is a multi-user, multi-threaded SQL database server. It is a
             : client/server implementation consisting of a server daemon (mysqld)
             : and many different client programs and libraries. This package contains
             : the MariaDB server and some accompanying files and directories.
             : MariaDB is a community developed branch of MySQL.

[root@server ~]# yum -y install mariadb-server

编译安装

1. 源码文件

[root@client mariadb]# pwd
/root/mariadb
[root@client mariadb]# ll
total 86308
-rw-r--r-- 1 root root  9460071 Feb 14 07:23 cmake-3.17.0-rc1.tar.gz
-rw-r--r-- 1 root root 78915056 Feb  7 23:42 mariadb-10.5.0.tar.gz

2. 创建mysql用户和组

[root@client mariadb]# useradd -r -M -s /sbin/nologin mysql

3. 创建安装目录

[root@client mariadb]# mkdir /opt/{cmake,mariadb}
[root@client mariadb]# chown mysql.mysql /opt/mariadb/

4. 解压源码包

[root@client mariadb]# tar -xf cmake-3.17.0-rc1.tar.gz 
[root@client mariadb]# tar -xf mariadb-10.5.0.tar.gz 
[root@client mariadb]# ll
total 86316
drwxrwxr-x 11 root root     4096 Feb 12 10:32 cmake-3.17.0-rc1
-rw-r--r--  1 root root  9460071 Feb 14 07:23 cmake-3.17.0-rc1.tar.gz
drwxrwxr-x 34 1001 1001     4096 Nov 28 10:19 mariadb-10.5.0
-rw-r--r--  1 root root 78915056 Feb  7 23:42 mariadb-10.5.0.tar.gz

5. 准备编译环境

[root@client mariadb]# yum -y groupinstall "Development Tools"

6. 依赖安装
   根据编译错误提示安装对应依赖
7. 安装cmake

[root@client mariadb]# cd cmake-3.17.0-rc1/
[root@client cmake-3.17.0-rc1]# ./configure --prefix=/opt/cmake/
[root@client cmake-3.17.0-rc1]# echo $?
[root@client cmake-3.17.0-rc1]# make -j 2 && make install -j 2
[root@client cmake-3.17.0-rc1]# echo $?

8. 添加程序到bin

[root@client cmake-3.17.0-rc1]# cd /opt/cmake/
[root@client cmake]# ln -sv /opt/cmake/bin/* /bin/
'/bin/cmake' -> '/opt/cmake/bin/cmake'
'/bin/cpack' -> '/opt/cmake/bin/cpack'
'/bin/ctest' -> '/opt/cmake/bin/ctest'
[root@client mariadb-10.5.0]# readlink /bin/cmake 
/opt/cmake/bin/cmake
[root@client mariadb-10.5.0]# readlink /bin/cpack 
/opt/cmake/bin/cpack
[root@client mariadb-10.5.0]# readlink /bin/ctest 
/opt/cmake/bin/ctest

9. 依赖安装
   根据编译错误提示安装对应依赖
10. 编译mariadb

[root@client cmake]# cd /root/mariadb/mariadb-10.5.0/
[root@client mariadb-10.5.0]# cmake . -DCMAKE_INSTALL_PREFIX=/opt/mariadb -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DWITH_EXTRA_CHARSETS=all -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
[root@client mariadb-10.5.0]# echo $?
[root@client mariadb-10.5.0]# make -j 2 && make install -j 2
[root@client mariadb-10.5.0]# echo $?

11. 首次运行设置

[root@client mariadb-10.5.0]# cd /opt/mariadb/  #进入目录
[root@client mariadb]# chown -R mysql.mysql /opt/mariadb/  #修改属主属组
[root@client mariadb]# ln -sv /opt/mariadb/bin/* /bin/
[root@client mariadb]# ./scripts/mysql-install-db --basedir=/opt/mariadb/ --datadir=/opt/mariadb/data  #初始化数据库
[root@client mariadb]# chown -R mysql.mysql /opt/mariadb/  #修改属主属组
[root@client mariadb]# ./support-files/mysql.server start  #启动数据库

12. 设置开机启动

[root@client mariadb]# ln -sv /opt/mariadb/support-files/mysql.server /etc/init.d/mysqld
[root@client mariadb]# chkconfig --add mysqld
[root@client mariadb]# chkconfig on
[root@client mariadb]# chkconfig --list mysqld
[root@client mariadb]# chkconfig --list mysqld

mysqld         	0:off	1:off	2:on	3:on	4:on	5:on	6:off