MySQL5.7.20源码安装

一、获取MySQL5.7.20源码安装包，并上传至服务器

MySQL官网下载地址：https://dev.mysql.com/downloads/mysql/

下载版本：mysql-boost-5.7.20.tar.gz此版本带有boost。

二、安装依赖包

[root@xjfw3 ~]# yum -y install gcc gcc-c++ ncurses ncurses-devel cmake

三、操作系统环境和目录结构

1. [root@xjfw3 ~]# cat /etc/redhat-release

2. Red Hat Enterprise Linux Server release 6.3 (Santiago)

3. [root@xjfw3 ~]# df -h

4. Filesystem Size Used Avail Use% Mounted on

5. /dev/mapper/vg_local-lv_root

6. 20G 5.1G 14G 28% /

7. tmpfs 16G 76K 16G 1% /dev/shm

8. /dev/mapper/vg_local-lv_app

9. 40G 176M 38G 1% /app

10. /dev/sda1 485M 55M 405M 12% /boot

11. /dev/mapper/vg_local-lv_home

12. 4.0G 137M 3.7G 4% /home

13. /dev/sdb1 394G 2.8G 371G 1% /weblogic

四、添加mysql禁止登录的用户及目录规划

1. [root@xjfw3 ~]# groupadd mysql

2. [root@xjfw3 ~]# useradd -r -g mysql -s /sbin/nologin mysql

3. MySQL数据库目录划分：

4. mysql软件目录: /weblogic/mysql/mysql

5. mysql数据目录：/weblogic/mysql/datadir

6. mysql日志目录：/weblogic/mysql/logdir

7. [root@xjfw3 ~]# mkdir -p /weblogic/mysql/mysql

8. [root@xjfw3 ~]# mkdir -p /weblogic/mysql/datadir

9. [root@xjfw3 ~]# mkdir -p /weblogic/mysql/logdi

10. [root@xjfw3 ~]# cd /weblogic/

11. [root@xjfw3 weblogic]# chown -R mysql.mysql mysql/

五、解压MySQL并编译安装

1. 1、解压Mysql

2. [root@xjfw3 ~]# cd /root

3. [root@xjfw3 ~]# ls mysql-boost-5.7.20.tar.gz

4. mysql-boost-5.7.20.tar.gz

5. [root@xjfw3 ~]# tar -xvf mysql-boost-5.7.20.tar.gz

6. 2、编译安装

7. [root@xjfw3 ~]#

8. [root@xjfw3 ~]# cd /root/mysql-5.7.20/

9. [root@xjfw3 mysql-5.7.20]# cmake . \

10. > -DCMAKE_INSTALL_PREFIX=/weblogic/mysql/mysql \

11. > -DMYSQL_DATADIR=/weblogic/mysql/datadir \

12. > -DDOWNLOAD_BOOST=1 \

13. > -DWITH_BOOST=/root/mysql-5.7.20/boost \

14. > -DSYSCONFDIR=/etc \

15. > -DWITH_INNOBASE_STORAGE_ENGINE=1 \

16. > -DWITH_PARTITION_STORAGE_ENGINE=1 \

17. > -DWITH_FEDERATED_STORAGE_ENGINE=1 \

18. > -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

19. > -DWITH_MYISAM_STORAGE_ENGINE=1 \

20. > -DENABLED_LOCAL_INFILE=1 \

21. > -DENABLE_DTRACE=0 \

22. > -DDEFAULT_CHARSET=utf8 \

23. > -DDEFAULT_COLLATION=utf8_general_ci \

24. > -DWITH_EMBEDDED_SERVER=1

25. [root@xjfw3 mysql-5.7.20]# make & make install

26. （此过程时间比较长）

六、配置my.cnf文件

1. [root@xjfw3 mysql]# vi /etc/my.cnf

2.  

3. [client]

4. port=3306

5. socket=/weblogic/mysql/datadir/mysql.sock

6. default-character-set=utf8

7. [mysqld]

8. port=3306

9. user=mysql

10. socket=/weblogic/mysql/datadir/mysql.sock

11. pid-file=/weblogic/mysql/datadir/mysql.pid

12. basedir=/weblogic/mysql/mysql

13. datadir=/weblogic/mysql/datadir

14. tmpdir=/weblogic/mysql/tmpdir

15. character-set-server=utf8

16. log_error=/weblogic/mysql/logdir/mysql.err

17.  

18. server-id=2

19. log_bin=/weblogic/mysql/logdir/binlog

20.  

21. general_log_file=/weblogic/mysql/logdir/general_log

22. general_log=1

23.  

24. slow_query_log=ON

25. long_query_time=2

26. slow_query_log_file=/weblogic/mysql/logdir/query_log

27. log_queries_not_using_indexes=ON

28.  

29. "/etc/my.cnf" [New] 25L, 605C written

30. [root@xjfw3 mysql]#

七、初始化数据库

1. [root@xjfw3 datadir]# cd /weblogic/mysql/mysql/bin

2. [root@xjfw3 bin]# ./mysqld --initialize-insecure --user=mysql --basedir=/weblogic/mysql/mysql --datadir=/weblogic/mysql/datadir/data

八、安装ssl,可指定文件生成路径，默认为DATA里面

1. [root@xjfw3 datadir]# cd /weblogic/mysql/mysql/bin

2. [root@xjfw3 bin]# ./mysql_ssl_rsa_setup

3. Generating a 2048 bit RSA private key

4. ....................................+++

5. .....................................................................................+++

6. writing new private key to 'ca-key.pem'

7. -----

8. Generating a 2048 bit RSA private key

9. ....................................................................................................................+++

10. ..................................................................................................+++

11. writing new private key to 'server-key.pem'

12. -----

13. Generating a 2048 bit RSA private key

14. ..................................+++

15. ........+++

16. writing new private key to 'client-key.pem'

17. -----

18. [root@gsxjfw3 bin]#

九、启动数据库

1. [root@xjfw3 ~]# cp /weblogic/mysql/mysql/support-files/mysql.server /etc/init.d/msyqld

2. [root@xjfw3 support-files]# /etc/init.d/mysqld start

3. Starting MySQL.[ OK ]

4. [root@xjfw3 ~]# ps -ef | grep mysql

5. root 14979 1 0 19:57 pts/2 00:00:00 /bin/sh /weblogic/mysql/mysql/bin/mysqld_safe --datadir=/weblogic/mysql/datadir/data --pid-file=/weblogic/mysql/datadir/mysql.pid

6. mysql 15278 14979 0 19:57 pts/2 00:00:00 /weblogic/mysql/mysql/bin/mysqld --basedir=/weblogic/mysql/mysql --datadir=/weblogic/mysql/datadir/data --plugin-dir=/weblogic/mysql/mysql/lib/plugin --user=mysql --log-error=/weblogic/mysql/logdir/mysql.err --pid-file=/weblogic/mysql/datadir/mysql.pid --socket=/weblogic/mysql/datadir/mysql.sock --port=3306

7. root 15397 14855 0 20:04 pts/2 00:00:00 grep mysql

8. [root@xjfw3 ~]#

十、登录数据库并修改密码

1. [root@xjfw3 ~]# /weblogic/mysql/mysql/bin/mysql

2. Welcome to the MySQL monitor. Commands end with ; or \g.

3. Your MySQL connection id is 4

4. Server version: 5.7.20-log Source distribution

5.  

6. Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

7.  

8. Oracle is a registered trademark of Oracle Corporation and/or its

9. affiliates. Other names may be trademarks of their respective

10. owners.

11.  

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

13.  

14. mysql> alter user 'root'@'localhost' identified by 'mysql';

15. Query OK, 0 rows affected (0.00 sec)

16.  

17. mysql>

十一、修改环境变量

1. [root@xjfw3 ~]# vi /etc/profile

2. PATH=/weblogic/mysql/mysql/bin:/weblogic/mysql/mysql/lib:$PATH

3. export PATH

4. "/etc/profile" 80L, 1868C written

5. [root@xjfw3 ~]# source /etc/profile

6. [root@xjfw3 ~]#

至此Mysql安装完毕，源码安装过于繁琐。建议使用官方编译好的二进制文件安装