源码安装mysql5.7

1.源码安装5.7版本mysql

1.下载mysql软件:

网站:MySQL :: Download MySQL Community Server

2.将我们下载的MySQL软件传到linux虚拟机上:

yum install -y lrzsz #执行此命令,下载一个上传文件的工具
rz #执行rz来执行命令
ls:

image.png
3.创建一个存放软件的文件夹:

[root@mysql_summary ~]# mkdir soft
[root@mysql_summary ~]# ls
init.sh  mysql-boost-5.7.43.tar.gz  soft
[root@mysql_summary mysql-5.7.43]# useradd -s /sbin/nologin mysql #创建一个mysql用户
[root@mysql_summary ~]# tar -xf mysql-boost-5.7.43.tar.gz -C soft

image.png
4.解决源码编译安装依赖性问题:

[root@mysql_summary mysql-5.7.43]# yum install -y  gcc gcc-c++ cmake ncurses ncurses-devel bison openssl-devel.x86_64

5.使用cmake去配置文件:

cmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost

6.编译安装:

[root@mysql_summary mysql-5.7.43]# make -j2 && make install #双线程执行编译

7.创建mysql-files文件

[root@mysql_summary mysql]# rm -rf  /etc/my.cnf
[root@mysql_summary mysql]# mkdir mysql-files ; chown -R mysql:mysql mysql-files; chmod 750 mysql-files

8.创建配置文件my.cnf

[root@mysql_summary mysql]# vim /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock

9.初始化mysql 最后一行的最后几个字段就是root密码:

[root@mysql_summary mysql]# bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
...
2023-07-27T12:13:05.819160Z 1 [Note] A temporary password is generated for root@localhost: Odat,J;h8-,l

10.启动服务:

将脚本文件复制到init下
[root@mysql_summary mysql]# echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
[root@mysql_summary mysql]# source /etc/profile
[root@mysql_summary mysql]# echo $PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/usr/local/mysql/bin
[root@mysql_summary mysql]# cp support-files/mysql.server /etc/init.d/mysqld
[root@mysql_summary mysql]# service mysqld start

image.png
11.设置密码和安全设置:

[root@mysql_summary mysql]# mysql -uroot -p
Enter password:  #将上方密码输入在这里
mysql> set password="123456";

# bin/mysql_secure_installation

最后将所有过程进行了整理:
打成了一个一键化脚本:

#!/bin/bash
#写一个shell脚本文件,实现MySQL的源码一键化安装:
rm -rf /etc/my.cnf
useradd -s /sbin/nologin mysql
mkdir ~/soft
tar -xf mysql-5.7.43.tar.gz -C ~/soft
cd ~/soft/mysql-5.7.43
yum install -y  gcc gcc-c++ cmake ncurses ncurses-devel bison openssl-devel#安装源码安装的依赖性文件
pwd
cmake -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_BOOST=boost
make -j2 && make install #双线程执行编译
mkdir mysql-files ; chown -R mysql:mysql mysql-files; chmod 750 mysql-files
echo "[mysqld]\n basedir=/usr/local/mysql\n datadir=/usr/local/mysql/data\n socket=/tmp/sock"
touch /tmp/1.txt
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data &> /tmp/1.txt
echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile
cp support-files/mysql.server /etc/init.d/mysqld
service mysqld start

评论

暂无评论