1、系统环境（本站使用centos6.8_x64）

1 [root@centos ~]# cat /etc/redhat-release 
2 CentOS release 6.8 (Final)

2、yum安装MySQL依赖包

1 yum install ncurses-devel libaio-devel cmake -y
2 rpm -qa ncurses-devel libaio-devel cmake

3、创建MySQL用户

1 useradd -s /sbin/nologin -M mysql
2 id mysql

4、下载MySQL源码包到指定目录

1 cd /home/oldboy/tools/
2 wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.36.tar.gz
3 或本站提供百度云下载，如下：

5、下载完成后，解压并进入解压后的目录中

1 tar xf mysql-5.6.36.tar.gz
2 cd mysql-5.6.36

6、编译指定参数

 1 cmake . -DCMAKE_INSTALL_PREFIX=/application/mysql-5.6.36 \
 2 -DMYSQL_DATADIR=/application/mysql-5.6.36/data \
 3 -DMYSQL_UNIX_ADDR=/application/mysql-5.6.36/tmp/mysql.sock \
 4 -DDEFAULT_CHARSET=utf8 \
 5 -DDEFAULT_COLLATION=utf8_general_ci \
 6 -DWITH_EXTRA_CHARSETS=all \
 7 -DWITH_INNOBASE_STORAGE_ENGINE=1 \
 8 -DWITH_FEDERATED_STORAGE_ENGINE=1 \
 9 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
10 -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
11 -DWITH_ZLIB=bundled \
12 -DWITH_SSL=bundled \
13 -DENABLED_LOCAL_INFILE=1 \
14 -DWITH_EMBEDDED_SERVER=1 \
15 -DENABLE_DOWNLOADS=1 \
16 -DWITH_DEBUG=0

7、make安装

1 make && make install

8、创建软连接

1 ln -s /application/mysql-5.6.36/ /application/mysql

9、复制配置文件到/etc/my.cnf

1 [root@db01 mysql-5.6.36]# cp support-files/my*.cnf /etc/my.cnf
2 cp: overwrite `/etc/my.cnf'? y

10、初始化MySQL 

1 /application/mysql/scripts/mysql_install_db --basedir=/application/mysql/ --datadir=/application/mysql/data --user=mysql

11、授权MySQL用户

1 chown -R mysql.mysql /application/mysql/

12、制作启动文件

1 cp support-files/mysql.server /etc/init.d/mysqld

13、给予权限

1 chmod 700 /etc/init.d/mysqld

14、设置开机启动并查看是否成功

1 chkconfig mysqld on
2 chkconfig --list mysqld

15、增加MySQL环境变量

1 echo 'PATH=/application/mysql/bin/:$PATH' >>/etc/profile
2 tail -1 /etc/profile
3 source /etc/profile
4 echo $PATH

16、（现在启动一般会报tmp或者以主机名命名的.err,，先来创建一下吧)填了无数坑，还是先记录下吧

1 mkdir /application/mysql/tmp
2 chown -R mysql.mysql /application/mysql/

17、开始启动MySQL……

1 /etc/init.d/mysqld start
2 netstat -lntup|grep 330

 18、增加MySQL登录密码

mysqladmin -u root password 'oldboy123'

19、登录MySQL……

[root@centos ~]# mysql -uroot -poldboy123
Warning: Using a password on the command line interface can be insecure.
Server version: 5.6.36 Source distribution

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

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>

出现以上信息，那么恭喜你已经部署完成。

 

版权声明：本文为wangqiner原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/wangqiner/p/9081002.html