从mysql-5.6开始，Mysql改为用cmake编译安装。安装方法如下：
一、检查&安装cmake
[root@Mysql-249 ~]# rpm -qa cmake
cmake-2.8.12.2-4.el6.x86_64
如未安装，用yum方式安装cmake
yum install cmake -y
安装其他依赖包
yum install gcc gcc-c++ cmake ncurses-devel bison perl  -y
二、环境配置
[root@Mysql-249 ~]#mkdir -p  /www/data
[root@Mysql-249 ~]#useradd mysql
[root@Mysql-249 ~]#chown -R mysql:mysql /www/data/
三、安装包准备
[root@Mysql-249 ~]# cd /usr/local/src/
[root@Mysql-249 src]# wget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.30.tar.gz
[root@Mysql-249 src]# tar -xzf mysql-5.6.30.tar.gz
[root@Mysql-249 src]# cd mysql-5.6.30
四、编译安装
[root@Mysql-249 mysql-5.6.30]# cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.6.30 \
-DMYSQL_DATADIR=/www/data \
-DSYSCONFDIR=/etc/my.cnf \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_UNIX_ADDR=/www/data/mysqld.sock \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DMYSQL_TCP_PORT=3306
[root@Mysql-249 mysql-5.6.30]# make && make install
五、修改Mysql配置文件
[root@Mysql-249 mysql-5.6.30]# cat  > /etc/my.cnf <
[mysqld]
datadir=/www/data
socket=/www/data/mysqld.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/www/data/mysqld.log
pid-file=/www/data/mysqld.pid
EOF
六、添加Mysql服务，配置开机自动启动
[root@Mysql-249 mysql-5.6.30]#cp /usr/local/mysql-5.6.30/support-files/mysql.server  /etc/init.d/mysqld
[root@Mysql-249 mysql-5.6.30]#chkconfig --add mysqld
[root@Mysql-249 mysql-5.6.30]#chkconfig mysqld --level 345 on
七、初始化数据库，设置Mysql超级用户密码
[root@Mysql-249 mysql-5.6.30]# ln -s /usr/local/mysql-5.6.30 /usr/local/mysql
[root@Mysql-249 mysql-5.6.30]# ln -s /usr/local/mysql/bin/* /usr/bin/
[root@Mysql-249 mysql-5.6.30]# ln -s /usr/local/mysql/include/* /usr/local/include/
[root@Mysql-249 mysql-5.6.30]# /usr/local/mysql/scripts/mysql_install_db  --basedir=/usr/local/mysql  --datadir=/www/data/  --user=mysql
[root@Mysql-249 mysql-5.6.30]# /etc/init.d/mysqld start
[root@Mysql-249 mysql-5.6.30]# /usr/local/mysql/bin/mysql_secure_installation
八、Mysql测试
[root@Mysql-249 mysql-5.6.30]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.30 Source distribution
Copyright (c) 2000, 2016, 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> \s
--------------
mysql  Ver 14.14 Distrib 5.6.30, for Linux (x86_64) using  EditLine wrapper
Connection id:          1
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.6.30 Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /www/data/mysqld.sock
Uptime:                 16 sec
Threads: 1  Questions: 5  Slow queries: 0  Opens: 70  Flush tables: 1  Open tables: 63  Queries per second avg: 0.312
--------------
编译参数说明：
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.6.30#Mysql安装路径
-DMYSQL_DATADIR=/www/data#数据存放路径
-DSYSCONFDIR=/etc/my.cnf#配置文件路径
-DWITH_MYISAM_STORAGE_ENGINE=1#支持MyISAM存储引擎
-DWITH_INNOBASE_STORAGE_ENGINE=1#支持INNODB存储引擎
-DWITH_MEMORY_STORAGE_ENGINE=1#支持MEMORY引擎
-DWITH_ARCHIVE_STORAGE_ENGINE=1#支持ARCHIVE引擎
-DWITH_PARTITION_STORAGE_ENGINE=1#支持数据库分区
-DWITH_READLINE=1#支持快捷键
-DMYSQL_UNIX_ADDR=/www/data/mysqld.sock#Unixsocket文件路径
-DENABLED_LOCAL_INFILE=1#允许本地导入数据库
-DEXTRA_CHARSETS=all#安装所有字符集
-DDEFAULT_CHARSET=utf8#设置默认字符集为UTF8
-DDEFAULT_COLLATION=utf8_general_ci#设置默认字符校验
-DMYSQL_TCP_PORT=3306#设置Mysql端口

linux下用cmake编译安装mysql-5.6.35
cmake编译安装mysql的方法：
#useradd -M mysql -s /sbin/nologin
#yum install -y cmake
#tar zxvf mysql-5.6.35.tar.gz
#cd mysql-5.6.35
创建数据存放目录
#mkdir /data/mysql
创建用户及用户组并指定之上的目录，用户及用户组
#useradd -M mysql -s /sbin/nologin
#chown -R mysql.mysql /data/mysql
预编译
#cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql\
-DMYSQL_DATADIR=/data/mysql\
-DWITH_MYISAM_STORAGE_ENGINE=1\
-DWITH_INNOBASE_STORAGE_ENGINE=1\
-DWITH_ARCHIVE_STORAGE_ENGINE=1\
-DWITH_BLACKHOLE_STORAGE_ENGINE=1\
-DENABLED_LOCAL_INFILE=1\
-DDEFAULT_CHARSET=utf8\
-DDEFAULT_COLLATION=utf8_general_ci\
-DEXTRA_CHARSETS=all\
-DMYSQL_TCP_PORT=3306\
-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock\
-DWITH_DEBUG=0
编译安装
#make && make install
编译出错，删除下面文件，重新编译安装。
#rm -f CMakeCache.txt
#make && make install
拷备配置文件及启动文件到指定目录下
#cp support-files/my-medium.cnf /etc/my.cnf
#cp support-files/mysql.server /etc/init.d/mysqld
修改配置文件my.cnf
加入basedir=/usr/local/mysql
修改启动脚本mysqld
加入或修改
basedir=/usr/local/mysql
datadir=/data/mysql
#chmod 755 /usr/local/mysql/scripts/mysql_install_db
#chown -R mysql.mysql /usr/local/mysql/
初始化权限
#/usr/local/mysql/scripts/mysql_install_db
--user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/
将mysql服务命令目录加入path环境变量中。
#echo "export PATH=$PATH:/usr/local/mysql/bin" >>/etc/profile
#source /etc/profile
修改mysql用户登录密码
#/usr/local/mysql/bin/mysqladmin -uroot password 123456
#/usr/local/mysql/bin/mysql -uroot -p123456

本文实例讲述了centos7环境下二进制安装包安装 mysql5.6的方法。分享给大家供大家参考，具体如下：
centos7 二进制安装包安装 mysql5.6
一、下载mysql5.6二进制安装包
http://mirrors.sohu.com/mysql/MySQL-5.6/
如:mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz
二、安装mysql5.6(安装在/data/mysql56)
(1)、创建mysql用户账号
> useradd -s /sbin/nologin -M mysql
(2)、解压压缩包
> tar xf mysql-5.6.34-linux-glibc2.5-x86_64.tar.gz
(3)、重命名
> mv mysql-5.6.34-linux-glibc2.5-x86_64 mysql56
(4)、复制配置文件
> cp /data/mysql56/support-files/my-default.cnf /etc/my.cnf
修改配置文件
[client]
port = 3306
socket = /data/mysql56/mysql.sock
default-character-set = utf8
[mysqld]
skip-name-resolve
user = mysql
basedir = /data/mysql56
datadir = /data/mysql56/data
port = 3306
server_id = 10
socket = /data/mysql56/mysql.sock
pid-file = /data/mysql56/mysql.pid
log-error = /data/mysql56/data/mysql.err
log-bin = /data/mysql56/data/mysql-bin
character-set-server = utf8
(*二进制安装，默认配置文件在/etc/my.cnf)
(5)、初始化数据库
> chown -R mysql.mysql /data/mysq56
> /data/mysql56/scripts/mysql_install_db \
--defaults-file=/etc/my.cnf \
--user=mysql \
--basedir=/data/mysql56 \
--datadir=/data/mysql56/data
如果出现如下信息
FATAL ERROR: please install the following Perl modules before executing
Data::Dumper
> yum -y install autoconf
此包安装时会安装Data:Dumper模块
三、配置并启动mysql
> cp /data/mysql56/support-files/mysql.server /etc/init.d/mysqld
> chmod 755 /etc/init.d/mysqld
(*注意,mysql二进制安装默认的路径为/usr/local/mysql,启动脚本里/usr/local/mysql需要替换)
> sed -i 's#/usr/local/mysql#/data/mysql56#g' /data/mysql56/bin/mysqld_safe /etc/init.d/mysqld
启动mysql
> service mysqld start
四、添加自启动
> chkconfig --add mysqld
> chkconfig mysqld on
> chkconfig --list mysqld
五、配置环境变量
> echo 'export PATH=/data/mysql56/bin:$PATH' >> /etc/profile
> source /etc/profile
六、修改mysql密码(mysql5.6安装默认root密码为空)
> mysqladmin -u root password '123456'
七、清理无用的mysql用户及库
登陆mysql
> mysql -uroot -p
查询用户
> select user,host from mysql.user;
如下所示
+------+-----------------------+
| user | host                  |
+------+-----------------------+
| root | 127.0.0.1             |
| root | ::1                   |
|      | localhost             |
| root | localhost             |
|      | localhost.localdomain |
| root | localhost.localdomain |
+------+-----------------------+
> drop user "root"@"::1";
> drop user ""@"localhost";
> drop user ""@"localhost.localdomain";
> drop user "root"@"localhost.localdomain";
删除无用库
> drop database test;
更多关于MySQL相关内容感兴趣的读者可查看本站专题：《MySQL查询技巧大全》、《MySQL常用函数大汇总》、《MySQL日志操作技巧大全》、《MySQL事务操作技巧汇总》、《MySQL存储过程技巧大全》及《MySQL数据库锁相关技巧汇总》
希望本文所述对大家MySQL数据库计有所帮助。
本文标题: centos7环境下二进制安装包安装 mysql5.6的方法详解
本文地址: http://www.cppcns.com/shujuku/mysql/300799.html

创建程序目录。mkdir /application
进入目录 cd  /home/oldboy/tools
下载到本地  wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.38-linux-glibc2.12-i686.tar.gz
解压软件包  tar xf mysql-5.6.21-linux-glibc2.5-x86_64.tar.gz
移动到程序目录，mv mysql-5.6.21-linux-glibc2.5-x86_64 /application/mysql-5.6
建立软连接，以后方便升级 ln -s  /application/mysql-5.6  /application/mysql
进入目录  cd /application/mysql
创建mysql用户   useradd -M -s /sbin/nologin mysql
初始化数据库
/application/mysql/scripts/mysql_install_db --basedir=/application/mysql   --datadir=/application/mysql/data --user=mysql
--basedir= 指定数据库初始目录
--datadir= 指定数据库存放数据目录
--user= 指定数据库启动用户为mysql
复制启动文件
cp /application/mysql/support-files/mysql.server /etc/init.d/mysqld
授权(默认是有执行权限)
chmod +x /etc/init.d/mysqld
修改启动路径
软件包默认mysql路径为 /usr/local/mysql
sed -i ‘s#/usr/local/mysql#/application/mysql#g‘ /application/mysql/bin/mysqld_safe /etc/init.d/mysqld
复制默认的配置文件
系统第一个会去找/etc/my.cfg
第二次会去找  /application/mysql/support-files/my-default.cnf 这个文件
第三次会找mysql启动时命令行带的参数
\cp /application/mysql/support-files/my-default.cnf /etc/my.cnf
启动
完成以上步骤mysql就可以启动运行了
service mysqld start
复制命令到bin
cp /application/mysql/bin/mysql /bin/
开启启动
Centos6
chkconfig --add mysqld ;chkconfig mysqld on
Centos7
systemctl   enable msyqld
mysql设置密码
mysqladmin -uroot password ‘密码‘
也可也进入数据库里面修改密码
mysql -u root mysql
mysql > UPPATE user SET password=PASSWORD(‘newpassword’) where USER=’root’;
mysql > FLUSH PRIVILEGES;
mysql > quit ;
/etc/init.d/mysql restart
mysql -u root -p
MySQL5.6版本压缩包安装
标签：路径   use   script   post   系统   三次   quit   mysql5.6   emctl
本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源：https://www.cnblogs.com/a-can/p/13121103587__csc.html