CentOS7源码编译安装mysql5.7版本

准备环境：

       CentOS7.9

准备软件：

      mysql-5.7.40

创建mysql组mysql用户
[root@localhost ~]#  groupadd mysql
[root@localhost ~]#  useradd -M -g mysql -s /sbin/nologin mysql

创建mysql目录
[root@localhost ~]# mkdir /usr/local/mysql
[root@localhost ~]# mkdir -p /usr/local/mysql{data,log,tmp}
[root@localhost ~]# chown -R mysql:mysql /usr/local/mysql

安装mysql依赖包
[root@localhost ~]#  yum -y groupinstall "Development Tools"
[root@localhost ~]#  yum -y install wget ncurses ncurses-devel openssl-devel bison libgcrypt gcc gcc-c++ make cmake

下载并解压mysql
[root@localhost ~]#  wget https://cdn.mysql.com/archives/mysql-5.7/mysql-boost-5.7.40.tar.gz
[root@localhost ~]#  tar zxvf mysql-boost-5.7.40.tar.gz -C /usr/src/
[root@localhost ~]#  cd /usr/src/mysql-5.7.40/
[root@localhost mysql-5.7.40]#  cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/ -DINSTALL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DMYSQL_USER=mysql -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1  -DWITH_MEMORY_STORAGE_ENGINE=1 -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/src/mysql-5.7.40/boost   -DWITH_MEMORY_STORAGE_ENGINE=1 -DMYSQL_USER=mysql -DWITH_EMBEDDED_SERVER=OFF

[root@localhost mysql-5.7.40]# make -j8 && make install

初始化数据库

[root@localhost mysql-5.7.40]# cd /usr/local/mysql
[root@localhost mysql]#  chown -R mysql:mysql .
初始化mysql
[root@localhost mysql]#  ./bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

 最后面的字母是装完mysql的默认密码 记住他！稍后再改

在配置文件添加以下内容

[root@localhost ~]#  vim /etc/my.cnf
[client]
port=3306
socket=/usr/local/mysql/tmp/mysql.sock


[mysqld]
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/tmp/mysql.sock
pid-file=/usr/local/mysql/tmp/mysql.pid
character_set_server=utf8
default_storage_engine=InnoDB
user=mysql
log_error=/usr/local/mysql/log/error.log

     

配置mysqld服务的管理工具             

[root@localhost ~]# ln -sv /usr/local/mysql/bin/* /usr/bin/
[root@localhost ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld 
[root@localhost ~]# chkconfig --add mysqld
[root@localhost ~]# chkconfig mysqld on

MySQL启动方式

[root@localhost ~]# /etc/init.d/mysqld start 

[root@localhost ~]# /etc/init.d/mysqld stop

[root@localhost ~]# /etc/init.d/mysqld restart 

或者

[root@localhost ~]# systemctl start mysqld

[root@localhost ~]# systemctl stop mysqld

[root@localhost ~]# systemctl restart mysqld

启动MySQL
[root@localhost ~]# systemctl start mysqld
报错信息如下：
ERROR 2002 (HY000): Can't connect to local MySQL server through socket /usr/local/mysql/tmp/mysql.sock

解决：
[root@localhost ~]# cd /usr/local/mysql/
[root@localhost mysql]# ./support-files/mysql.server start
Starting MySQL SUCCESS!   ##启动成功

如果还报错，报错信息如下：
. ERROR! The server quit without updating PID file (/usr/local/mysql/tmp/mysql.pid）

解决：
[root@localhost ~]# touch /usr/local/mysql/tmp/mysql.pid 
[root@localhost ~]# touch /usr/local/mysql/log/error.log
[root@localhost ~]#  chmod -R 777 /usr/local/mysql/
[root@localhost ~]# chown mysql:mysql /usr/local/mysql -R


再次启动
[root@localhost mysql]# ./support-files/mysql.server start
Starting MySQL SUCCESS!   ##启动成功

             

修改mysql密码并登录

[root@localhost mysql]# mysqladmin -uroot -p'7<&BiP2aAda' password 123123

格式：mysqladmin -uroot -p'默认密码/老密码'     password 新密码

登录MySQL
[root@localhost ~]# mysql -uroot -p123123
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.40 Source distribution

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 


登录成功

数据库安装成功