Linux系统MySQL数据库部署

MySQL数据库部署

方式一：仓库安装

• 获取仓库

rpm -i https://repo.mysql.com//mysql80-community-release-el8-4.noarch.rpm

• 安装MySQL服务

dnf install mysql-server

• 查看MySQL安装包

rpm -qa | grep mysql

• 启动服务

systemctl start mysqld

• 登录MySQL

[root@localhost ~]# mysql -uroot -p 

方式二：本地安装

• 下载MySQL tar包

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.30-1.el8.x86_64.rpm-bundle.tar

• 解压缩tar包

tar xvf mysql-8.0.30-1.el8.x86_64.rpm-bundle.tar

• 安装MySQL

dnf localinstall mysql-community-server-8.0.30-1.el8.x86_64.rpm \
mysql-community-client-8.0.30-1.el8.x86_64.rpm \
mysql-community-common-8.0.30-1.el8.x86_64.rpm \
mysql-community-icu-data-files-8.0.30-1.el8.x86_64.rpm  \
mysql-community-client-plugins-8.0.30-1.el8.x86_64.rpm \
mysql-community-libs-8.0.30-1.el8.x86_64.rpm

• 启动MySQL

[root@localhost ~]# systemctl start mysqld

• 登录MySQL

[root@localhost ~]# mysql -uroot -p

方式三：源码安装（企业常用）

• 下载MySQL源码包

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-boost-8.0.30.tar.gz

• Preconfiguration setup

groupadd mysql
useradd -r -g mysql -s /bin/false mysql

• Beginning of source-build specific instructions

tar zxvf mysql-VERSION.tar.gz
cd mysql-VERSION
mkdir bld
cd bld

• install cmake

yum install cmake \
gcc-toolset-11-gcc \
gcc-toolset-11-gcc-c++ \
gcc-toolset-11-binutils \
openssl-devel \
ncurses-devel \
libtirpc-devel -y

• 安装rpcgen仓库源

rpm -i rpcgen-1.3.1-4.el8.x86_64.rpm 

cmake .. -DWITH_BOOST=../boost/boost_1_77_0/

• 编译安装（此操作建议在linux终端执行，不要在远程终端执行; 需要编译四个小时左右）

[root@localhost bld]# make;make install

• End of source-build specific instructions
• Postinstallation setup

cd /usr/local/mysql
mkdir mysql-files
chown mysql:mysql mysql-files
chmod 750 mysql-files
bin/mysqld --initialize --user=mysql
bin/mysql_ssl_rsa_setup
bin/mysqld_safe --user=mysql &

• Next command is optional

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