1、安装包下载
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-boost-5.7.29.tar.gz
(该包包含了boost头文件的包,就不用单独再去下载boost包)
yum install -y wget cmake make bison bison-devel libaio-devel gcc gcc-c++ git ncurses-devel openssl-devel
cmake ./ -DCMAKE_BUILD_TYPE=Debug -DWITH_BOOST=boost/boost_1_59_0/ -DCMAKE_INSTALL_PREFIX=/data/mysql/base/5.7.29
用cmake进行编译配置
-DCMAKE_BUILD_TYPE=Debug 是指明编译出一个用来debug(跟踪代码)的版本;
-DWITH_BOOST=…/mysql-8.0.15/boost/boost_1_59_0/ 指明boost头文件在哪;-DCMAKE_INSTALL_PREFIX=/data/mysql/base/5.7.29 指明将来make install的时候,把MySQL软件安装在哪里,不设置的话,缺省是/usr/local/mysql;
如果没有报错就直接安装
make install
(这个过程比较漫长…)
[root@localhost base]# ls -l 5.7.29/
总用量 296
drwxr-xr-x. 2 root root 4096 6月 10 16:25 bin
drwxr-xr-x. 2 root root 55 6月 10 16:23 docs
drwxr-xr-x. 3 root root 4096 6月 10 16:23 include
drwxr-xr-x. 4 root root 192 6月 10 16:25 lib
-rw-r--r--. 1 root root 276202 12月 18 20:59 LICENSE
drwxr-xr-x. 4 root root 30 6月 10 16:23 man
drwxr-xr-x. 10 root root 4096 6月 10 16:27 mysql-test
-rw-r--r--. 1 root root 587 12月 18 20:59 README
-rw-r--r--. 1 root root 587 12月 18 20:59 README-test
drwxr-xr-x. 28 root root 4096 6月 10 16:27 share
drwxr-xr-x. 2 root root 90 6月 10 16:27 support-files
至此,编译安装已经完成了。
创建MySQL所使用的用户组和用户,并且更改datadir的属主和属组
然后初始化,并且启动数据库
mkdir data_3307
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /data/mysql/data_3307/
bin/mysqld --defaults-file=/data/mysql/etc_3307/my.cnf --initialize --user=mysql
[root@localhost data_3307]# ls -l
总用量 110664
-rw-r-----. 1 mysql mysql 56 6月 10 16:39 auto.cnf
-rw-------. 1 mysql mysql 1680 6月 10 16:39 ca-key.pem
-rw-r--r--. 1 mysql mysql 1112 6月 10 16:39 ca.pem
-rw-r--r--. 1 mysql mysql 1112 6月 10 16:39 client-cert.pem
-rw-------. 1 mysql mysql 1680 6月 10 16:39 client-key.pem
-rw-r-----. 1 mysql mysql 1064 6月 10 16:39 error.log
-rw-r-----. 1 mysql mysql 425 6月 10 16:39 ib_buffer_pool
-rw-r-----. 1 mysql mysql 12582912 6月 10 16:39 ibdata1
-rw-r-----. 1 mysql mysql 50331648 6月 10 16:39 ib_logfile0
-rw-r-----. 1 mysql mysql 50331648 6月 10 16:39 ib_logfile1
drwxr-x---. 2 mysql mysql 4096 6月 10 16:39 mysql
drwxr-x---. 2 mysql mysql 8192 6月 10 16:39 performance_schema
-rw-------. 1 mysql mysql 1676 6月 10 16:39 private_key.pem
-rw-r--r--. 1 mysql mysql 452 6月 10 16:39 public_key.pem
-rw-r--r--. 1 mysql mysql 1112 6月 10 16:39 server-cert.pem
-rw-------. 1 mysql mysql 1680 6月 10 16:39 server-key.pem
drwxr-x---. 2 mysql mysql 8192 6月 10 16:39 sys
[root@localhost data_3307]# more error.log
2020-06-10T08:39:16.714908Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-06-10T08:39:16.715956Z 0 [ERROR] Can't find error-message file '/usr/local/8.0/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2020-06-10T08:39:19.508365Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-06-10T08:39:20.093877Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-06-10T08:39:20.228856Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e0bb13ba-aaf5-11ea-8350-000c29c3b291.
2020-06-10T08:39:20.230806Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-06-10T08:39:21.264733Z 0 [Warning] CA certificate ca.pem is self signed.
2020-06-10T08:39:21.464008Z 1 [Note] A temporary password is generated for root@localhost: zlkfobsBQ6,s
然后就可以启动
[root@localhost 8.0]# ./bin/mysqld_safe --defaults-file=/data/mysql/etc_3307/my.cnf --user=mysql &
这里可以修改临时密码。
alter user root@'localhost' identified by 'xxx';
flush privileges;