完成四种方式的MySQL安装并记录过程

最新推荐文章于 2025-10-02 23:41:01 发布

原创最新推荐文章于 2025-10-02 23:41:01 发布 · 144 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #数据库 #linux

开发-数据库和python 专栏收录该内容

11 篇文章

订阅专栏

该文详细介绍了如何在仓库、本地、容器及通过源码方式安装MySQL。包括使用RPM包管理器dnf和yum，以及Docker容器的运用，还涉及到了源码编译安装的过程，包括配置选项和依赖处理。

1、仓库安装

rpm -i https://repo.mysql.com//mysql80-community-release-el8-4.noarch.rpm
dnf install mysql-server
rpm -qa | grep mysql

systemctl start mysqld
systemctl status mysqld

2、本地安装

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

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

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

[root@localhost ~]# systemctl start mysqld
[root@localhost ~]# systemctl status mysqld

3、容器安装

yum-config-manager --add-repo https://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
ll /etc/yum.repos.d/
dnf install docker-ce docker-ce-cli
systemctl start docker
systemctl status docker
docker version
docker run hello-world
docker run mysql
docker ps
docker run --name mysqltest -e MYSQL_ROOT_PASSWORD=123456 -d mysql
docker ps
docker run --name mysqltest2 -e MYSQL_ROOT_PASSWORD=123456 -d mysql
netstat -lntup | grep 3306
docker ps
docker --help

docker exec mysqltest2 /bin/bash
dnf install bash-com*

docker exec -it mysqltest2 /bin/bash
docker ps
docker run --name mysqltest3 -e MYSQL_ROOT_PASSWORD=123456 -d mysql
docker ps
docker run --name mysqltest5 -e MYSQL_ROOT_PASSWORD=123456 -d mysql
docker ps
history

4、源码安装

上传mysql安装包和boost安装包到我们的服务器

yum -y remove boost-*
rpm -ivh mysql-community-5.7.26-1.el7.src.rpm
 yum install -y bzip2
cd /root/rpmbuild/SOURCES/
tar  -jxvf  boost_1_59_0.tar.bz2  -C  /root/
yum install -y cmake make gcc gcc-c++ bison ncurses ncurses-devel
groupadd mysql
useradd -M -s /sbin/nologin -r -g mysql mysql
mkdir -p /data/mysql/{data,log}
chown -R mysql:mysql /data/mysql
cd /root/rpmbuild/SOURCES/
tar  -zxvf mysql-5.7.26.tar.gz  -C  /root/
cd mysql-5.7.26
 cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
 -DMYSQL_DATADIR=/data/mysql/data \
 -DSYSCONFDIR=/etc \
 -DWITH_MYISAM_STORAGE_ENGINE=1 \
 -DWITH_INNOBASE_STORAGE_ENGINE=1 \
 -DWITH_MEMORY_STORAGE_ENGINE=1 \
 -DWITH_READLINE=1 \
 -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
 -DMYSQL_TCP_PORT=3306 \
 -DENABLED_LOCAL_INFILE=1 \
 -DWITH_PARTITION_STORAGE_ENGINE=1 \
 -DEXTRA_CHARSETS=all \
 -DDEFAULT_CHARSET=utf8 \
 -DDEFAULT_COLLATION=utf8_general_ci \
 -DDOWNLOAD_BOOST=1 \
 -DWITH_BOOST=/root/boost_1_59_0
make  -j  $( grep processor /proc/cpuinfo | wc -l)
grep processor /proc/cpuinfo | wc -l
make install
chown -R mysql:mysql /usr/local/mysql/
vim /etc/my.cnf
 [mysqld]
 basedir=/usr/local/mysql        
 datadir=/data/mysql/data     
 port=3306                 
 socket=/usr/local/mysql/mysql.sock 
 symbolic-links=0           
 character-set-server=utf8       
 log-error=/data/mysql/log/mysqld.log    
 pid-file=/usr/local/mysql/mysqld.pid 
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld