mysql 5.6.28源码安装
众所周知,mysql5.5版本之前都是通过./configure进行编译环境检查，mysql5.5之后用的是cmake(包括5.5)安装前的准备工作：
1、安装epel源
1
2
#wgethttps://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
#rpm -ivh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
2、安装开发工具包和ncurses-devel
1
2
#yum -y groupinstall "Development Tools"
#yum -y install ncurse ncurses-devel
第一部分 编译安装
一、安装环境
1、mysql源码包
sohu镜像站：http://mirrors.sohu.com/mysql/
2、cmake
cmake的重要特性之一是其独立于源码(out-of-source)的编译功能，即编译工作可以在另一个指定的目录中而非源码目录中进行，这可以保证源码目录不受任何一次编译的影响，因此在同一个源码树上可以进行多次不同的编译，如针对于不同平台编译。
(1)源码安装方式
https://cmake.org/download/
1
2
3
4
5
6
# wget https://cmake.org/files/v2.8/cmake-2.8.8.tar.gz
# tar xf cmake-2.8.8.tar.gz
# cd cmake-2.8.8
# ./bootstrap
# make
# make install
(2) yum安装方式
1
#yum install cmake
二、mysql5.6.28源码安装方法
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
# wgethttp://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.28.tar.gz
# tar -zxvfmysql-5.6.28.tar.gz
# cdmysql-5.6.28
#cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql\
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DSYSCONFDIR=/etc\
-DWITH_MYISAM_STORAGE_ENGINE=1\
-DWITH_INNOBASE_STORAGE_ENGINE=1\
-DWITH_ ZMEMORY_STORAGE_ENGINE=1\
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock\
-DMYSQL_TCP_PORT=3306\
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1\
-DEXTRA_CHARSETS=all
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
环境检查过程中，若出现以下错误信息：
Curses library not found. Please install appropriate package,
remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.
解决方法为：
1
2
3
# rm -f ./CMakeCache.txt
# yum -y install ncurses-devel
# echo $?查看检查环境过程是否成功，0为成功，其它为失败
3、make编译
1
# make
4、make install安装
1
# make install
第二部分 配置mysql为系统服务
三、创建mysql用户和组
1
2
3
# groupadd mysql
# useradd -g mysql mysql
# chown -R mysql:mysql /usr/local/mysql
四、初始化mysql数据库
1
2
3
4
# cd /usr/local/mysql/scripts
# ls
mysql_install_db
# ./mysql_install_db--basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --user=mysql
注：只要出现了两个OK代表数据库初始化成功
五、复制my.cnf与mysql.server启动文件
1
2
3
4
5
6
#cd ..
# cd support-files/
# cp my-default.cnf /etc/my.cnf
cp：是否覆盖"/etc/my.cnf"？ y
# cp mysql.server /etc/init.d/mysqld
# chmod +x /etc/init.d/mysqld
六、开启mysqld服务
1
2
3
4
5
# service mysqld status
MySQL is not running [失败]
# service mysqld start
Starting MySQL......... [确定]
# chkconfig mysqld on
七、查看mysqld服务端口号
1
2
# netstat -tunlp | grep mysql
tcp 0 0 :::3306 :::* LISTEN 47557/mysqld
八、初始化数据库密码
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
# cd ..
# cd bin
# ./mysqladmin -u root password 'mysql'
Warning: Using a password on the command line interface can be insecure.
# ./mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.28 Source distribution
Copyright (c) 2000, 2015, 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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.04 sec)
mysql> exit
九、修改全局环境变量
1
2
3
4
5
6
7
8
9
10
11
12
13
14
# vim /etc/profile
56 export PATH=$PATH:/usr/local/mysql/bin
#source /etc/profile
# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.28 Source distribution
Copyright (c) 2000, 2015, 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>
十、客户端免密码登录设置
1
2
3
4
5
6
# vim.my.cnf
user = root
password = sa123456
host = localhost
#
页:
[1]