安装MysqL前的准备
一、安装依赖的库：
yum install gcc-c++ ncurses-devel perl-Data-Dumper python-devel openssl openssl-devel@H_404_12@
(yum -y install make gcc-c++ cmake bison-devel ncurses-devel)
@H_404_12@
1、安装cmake
安装cmake（因为MysqL5.7的编译由cmake来实现）@H_404_12@ 安装cmake：@H_404_12@ https://cmake.org/files/v2.8/cmake-2.8.8.tar.gz@H_404_12@ cd cmake-2.8.8/@H_404_12@ 预编译和安装：@H_404_12@ ./bootstrap@H_404_12@ Make && make install
@H_404_12@
2、安装boost
cd /usr/local/boost@H_404_12@ 下载源码包：@H_404_12@ wget http://jaist.dl.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.zip @H_404_12@ 解压@H_404_12@ unzip boost_1_59_0.zip @H_404_12@ cd /usr/local/boost/boost_1_59_0@H_404_12@ 编译安装：@H_404_12@ ./bootstrap.sh @H_404_12@ ./b2 @H_404_12@ sudo ./b2 install @H_404_12@ 配置环境变量：@H_404_12@ vim /etc/profile@H_404_12@ BOOST_ROOT=/usr/local/boost/boost_1_59_0@H_404_12@ BOOST_LIB=/usr/local/boost/boost_1_59_0/stage/lib@H_404_12@ BOOST_INCLUDE=/usr/local/include/boost@H_404_12@ export BOOST _ROOT BOOST _INCLUDE BOOST _LIB@H_404_12@ @H_404_12@ source /etc/profile@H_404_12@
@H_404_12@
二、下载MysqL源码包
1、下载源码包@H_404_12@
wget http://mirrors.sohu.com/MysqL/MysqL-5.7/MysqL-5.7.18.tar.gz
tar zxvf MysqL-5.7.18.tar.gz
cd MysqL-5.7.18/
编译和安装
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/MysqL -DMysqL_DATADIR=/mydata/data -DSYSCONFDIR=/etc -DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=1 -DWITH_ZLIB=1 -DWITH_LIBWRAP=1 -DWITH_UNIX_ADDR=/tmp/MysqL.sock -DMysqL_TCP_PORT=3306 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost/boost_1_59_0@H_404_12@
(备注：MysqL5.7的编译需指定boost,即：DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost/boost_1_59_0@H_404_12@
最后一行配置是下载boost包，如果没有boost包，编译会报错)
make
make install@H_404_12@
@H_404_12@
2、添加MysqL用户和组： @H_404_12@ groupadd -r MysqL@H_404_12@ useradd -g MysqL -r -d /mydata/data MysqL
chown -R MysqL:MysqL /usr/local/MysqL
初始化数据库@H_404_12@ bin/MysqL_install_db --user=MysqL --basedir=/usr/local/MysqL --datadir=/mydata/data # Before MysqL 5.6@H_404_12@ bin/MysqLd --initialize --user=MysqL --basedir=/usr/local/MysqL --datadir=/mydata/data # MysqL 5.7 and up
@H_404_12@
cp support-files/my-default.cnf /etc/my.cnf@H_404_12@ cp support-files/MysqL.server /etc/init.d/MysqLd@H_404_12@ chmod +x /etc/init.d/MysqLd
@H_404_12@
3、修改配置文件：@H_404_12@ vim /etc/my.cnf@H_404_12@ [client]@H_404_12@ port=3306@H_404_12@ socket=/tmp/MysqL.sock@H_404_12@ default-character-set=utf8@H_404_12@ [MysqLd]@H_404_12@ basedir =/usr/local/MysqL@H_404_12@ datadir =/mydata/data@H_404_12@ port =3306@H_404_12@ server_id =1@H_404_12@ socket =/tmp/MysqL.sock@H_404_12@ pid-file=/mydata/data/MysqL.pid@H_404_12@ @H_404_12@ bind-address=localhost@H_404_12@ #skip-grant-tables@H_404_12@
@H_404_12@
4、启动MysqL服务@H_404_12@ service MysqLd start@H_404_12@ @H_404_12@ 5、为了直接使用，加到环境变量里;修改/etc/profile文件，在文件末尾添加：@H_404_12@ vim /etc/profile@H_404_12@ PATH=/usr/local/MysqL/bin:$PATH@H_404_12@ export PATH@H_404_12@ :wq 保存退出@H_404_12@ 关闭文件，运行下面命令，让配置立即生效：@H_404_12@ source /etc/profile@H_404_12@
@H_404_12@
6、此时需要修改root用户密码，在初始化数据库是会随机生成一个密码@H_404_12@ @H_404_12@ 方法如下：@H_404_12@ 1）、vim /etc/my.cnf #编辑文件，找到[MysqLd]，在下面添加一行skip-grant-tables@H_404_12@ [MysqLd]@H_404_12@ skip-grant-tables@H_404_12@ :wq! #保存退出@H_404_12@ service MysqLd restart #重启MysqL服务@H_404_12@ 2）、进入MysqL控制台@H_404_12@ MysqL -uroot -p #直接按回车，这时不需要输入root密码。@H_404_12@ 3）、修改root密码 看下password名称authentication_string@H_404_12@ update MysqL.user set authentication_string=password('123456') where User="root" and Host="localhost";@H_404_12@ flush privileges; #刷新系统授权表@H_404_12@ grant all on *.* to 'root'@'localhost' identified by '123456' with grant option;@H_404_12@ 4）、取消/etc/my.cnf中的skip-grant-tables@H_404_12@ vi /etc/my.cnf 编辑文件，找到[MysqLd]，删除skip-grant-tables这一行@H_404_12@ :wq! #保存退出@H_404_12@ 5）、重启MysqL@H_404_12@ service MysqLd restart #重启MysqL，这个时候MysqL的root密码已经修改为123456@H_404_12@ 6）、进入MysqL控制台@H_404_12@ [root@localhost ~]# MysqL -u root -p @H_404_12@
@H_404_12@
MysqL>@H_404_12@ @H_404_12@ 至此MysqL5,7安装好了
@H_404_12@
若要设置root用户可以远程访问，执行: MysqL> GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.16.%' IDENTIFIED BY 'password' WITH GRANT OPTION; 红色的password为远程访问时，root用户的密码，可以和本地不同 配置防火墙 防火墙的3306端口默认没有开启，若要远程访问，需要开启这个端口打开/etc/sysconfig/iptables 在“-A INPUT –m state --state NEW –m tcp –p –dport 22 –j ACCEPT”，下添加: -A INPUT -m state --state NEW -m tcp -p -dport 3306 -j ACCEPT 然后保存，并关闭该文件，在终端内运行下面的命令，刷新防火墙配置: service iptables restart
