准备篇:
一、配置防火墙,开启80端口、3306端口CentOS 7.0默认使用的是firewall作为防火墙,这里改为iptables防火墙。1、关闭firewall:systemctl stop firewalld.service #停止firewallsystemctl disable firewalld.service #禁止firewall开机启动2、安装iptables防火墙yum install iptables-services #安装vi /etc/sysconfig/iptables #编辑防火墙配置文件# Firewall configuration written by system-config-firewall# Manual customization of this file is not recommended.*filter:INPUT ACCEPT [0:0]:FORWARD ACCEPT [0:0]:OUTPUT ACCEPT [0:0]-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT-A INPUT -p icmp -j ACCEPT-A INPUT -i lo -j ACCEPT-A INPUT -m state --state NEW -m tcp -p tcp --dport 22 -j ACCEPT-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT-A INPUT -j REJECT --reject-with icmp-host-prohibited-A FORWARD -j REJECT --reject-with icmp-host-prohibitedCOMMIT:wq! #保存退出systemctl restart iptables.service #最后重启防火墙使配置生效systemctl enable iptables.service #设置防火墙开机启动二、关闭SELINUXvi /etc/selinux/config#SELINUX=enforcing #注释掉#SELINUXTYPE=targeted #注释掉SELINUX=disabled #增加:wq! #保存退出setenforce 0 #使配置立即生效三 、系统约定软件源代码包存放位置:/usr/local/src源码包编译安装位置:/usr/local/mysql5.71、如果一定要在centos 7上安装mysql ,需要卸载MariaDB,否则会冲突。2、执行这个命令:rpm -qa | grep mariadbrpm -e mariadb-libs-5.5.44-2.el7.centos.x86_64 --nodeps1、安装cmake2、安装依赖包yum install -y gcc gcc-c++ make automake ncurses-devel链接:http://pan.baidu.com/s/1bpaOqa7 密码:r2jscmake:由于从MySQL5.5版本开始弃用了常规的configure编译方法,所以需要CMake编译器,用于设置mysql的编译参数。如:安装目录、数据存放目录、字符编码、排序规则等。
Boost:从MySQL 5.7.5开始Boost库是必需的,mysql源码中用到了C++的Boost库,要求必须安装boost1.59.0或以上版本GCC:是Linux下的C语言编译工具,mysql源码编译完全由C和C++编写,要求必须安装GCCbison:Linux下C/C++语法分析器ncurses:字符终端处理库1)安装文件准备下载cmake-3.5.2.tar.gz http://www.cmake.org/files/v3.5/cmake-3.5.2.tar.gz下载ncurses-5.9.tar.gz ftp://ftp.gnu.org/gnu/ncurses/下载bison-3.0.4.tar.gz http://ftp.gnu.org/gnu/bison/下载mysql-5.7.13.tar.gz wget http://cdn.mysql.com/Downloads/MySQL-5.7/mysql-5.7.13.tar.gz下载Boost_1_59_0.tar.gzwget http://nchc.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz2)安装CMAKE及必要的软件cd /usr/local/srctar zxf cmake-3.5.2tar.gzcd cmake-3.5.2./bootstrapgmakegmake install安装ncursestar zxf ncurses-5.9.tar.gz cd ncurses-5.9./configure &&make &&make install安装bisontar zxf bison-3.0.4.tar.gzcd bison-3.0.4./configure &&make &&make install安装boosttar zxf boost_1_59_0.tar.gzmv boost_1_59_0.tar.gz /usr/local/boost四.开始安装mysql
[root@localhost src]#groupadd mysql [root@localhost src]# useradd -g mysql mysql -s /bin/false[root@localhost src]# mkdir -p /data/server/mysql5.7/db/ 数据库存放目录[root@localhost src]# mkdir -p /data/server/mysql5.7/binlog/[root@localhost src]# chown mysql:mysql /data/server/mysql5.7/db/[root@localhost src]# chown mysql:mysql /data/server/mysql5.7/binlog/[root@localhost src]# mkdir -p /usr/local/mysql5.7 安装目录 tar xf mysql-5.7.13.tar.gz #解压cd mysql-5.7.13 #进入目录cmakecmake \-DCMAKE_INSTALL_PREFIX=/usr/local/mysql5.7 \-DSYSCONFDIR=/etc \-DMYSQL_DATADIR=/data/server/mysql5.7/db \-DMYSQL_USER=mysql \-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock \-DMYSQL_TCP_PORT=3306 \-DWITH_MYISAM_STORAGE_ENGINE=1 \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_ARCHIVE_STORABE_ENGINE=1 \-DWITH_MEMORY_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DEXTRA_CHARSETS=all \-DENABLED_LOCAL_INFILE=1 \-DWITH-SYSTEMD=1 \-DWITH_BOOST=/usr/local/boost编译安装
make && make install编译出错, 重新编译前要删除编译失败的文件,重新编译时,需要清除旧的对象文件和缓存信息。
make cleanrm -f CMakeCache.txtrm -rf /etc/my.cnf #删除系统默认的配置文件(如果默认没有就不用删除)cd /usr/local/mysql5.7 #进入MySQL安装目录初始化数据库
./bin/mysqld --user=mysql --initialize-insecure --basedir=/usr/local/mysql5.7/ --datadir=/data/server/mysql5.7/db/ #生成mysql系统数据库--initialize表示默认生成密码, --initialize-insecure 表示不生成密码, 密码为空。
看到这一行[Note] A temporary password is generated for root@localhost: i>X18*=Rav=7cp /usr/local/mysql5.7/support-files/my-default.cnf /usr/local/mysql5.7/my.cnf
ln -s /usr/local/mysql5.7/my.cnf /etc/my.cnf #添加到/etc目录的软连接cp /usr/local/mysql5.7/support-files/mysql.server /etc/rc.d/init.d/mysqld #把Mysql加入系统启动chmod 755 /etc/init.d/mysqldchkconfig mysqld onvi /etc/rc.d/init.d/mysqld #编辑basedir=/usr/local/mysql5.7
datadir=/data/server/mysql5.7/db:wq! #保存退出更改配置文件
/etc/my.cnf[mysqld]datadir=/data/server/mysql5.7/dbinnodb_lock_wait_timeout = 500max_allowed_packet = 16Minnodb_buffer_pool_size = 1G#lower_case_table_names = 1max_connections = 1024user = mysqlserver-id = 1skip-name-resolvesymbolic-links= 0innodb_file_per_table = 1event_scheduler= ONport = 3306character_set_server = utf8sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESlog-bin=/data/server/mysql5.7/binlog/log-DB.indexexpire_logs_days = 7pid-file=/data/server/mysql5.7/db/mysql.pid[root@VM7 mysql5.7]# service mysqld start #启动mysql
Starting MySQL.. SUCCESS!vi /etc/profile #把mysql服务加入系统环境变量:在最后添加下面这一行
export PATH=$PATH:/usr/local/mysql5.7/bin:wq! #保存退出source /etc/profile #使配置立刻生效
下面这两行把myslq的库文件链接到系统默认的位置,这样你在编译类似PHP等软件时可以不用指定mysql的库文件地址。
ln -s /usr/local/mysql5.7/lib/mysql /usr/lib/mysqlln -s /usr/local/mysql5.7/include/mysql /usr/include/mysqlmkdir /var/lib/mysql #创建目录ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock #添加软链接server restart msyqld #重启数据库
6.配置mysql 用户及密码>mysql
grant all on *.* to 'root'@'localhost' identified by 'mmog'; flush privileges;
至此:MySQL5.7 安装完毕
注意:
[root@VM7 mysql5.7]# mysql-bash: /usr/bin/mysql: 没有那个文件或目录原因:这是由于系统默认会查找/usr/bin下的命令,如果这个命令不在这个目录下,当然会找不到命令,我们需要做的就是映射一个链接到/usr/bin目录下,相当于建立一个链接文件。首先得知道mysql命令或mysqladmin命令的完整路径,比如mysql的路径是:/usr/local/mysql/bin/mysql,我们则可以这样执行命令:# ln -s /usr/local/mysql5.7/bin/mysql /usr/bin/