mysql5.7在centos7上的安装

nawawa001

　　--------------------------mysql5.7安装--------------------------------------
yum -y install gcc gcc-c++  cmake
yum -y install \
ncurses \
ncurses-devel \
bison \
　　useradd -s /sbin/nologin  mysql
　　tar zxvf mysql-5.7.17.tar.gz -C /opt/
tar zxvf boost_1_59_0.tar.gz -C /usr/local/
cd /usr/local/
mv boost_1_59_0 boost
　　cd mysql-5.7.17/
　　cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \
-DSYSCONFDIR=/etc \
-DSYSTEMD_PID_DIR=/usr/local/mysql \
-DDEFAULT_CHARSET=utf8  \
-DDEFAULT_COLLATION=utf8_general_ci \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DWITH_BOOST=/usr/local/boost \
-DWITH_SYSTEMD=1
　　------注意：如果在CMAKE的过程中有报错，当报错解决后，需要把源码目录中的CMakeCache.txt文件删除，然后再重新CMAKE，否则错误依旧------------
　　make && make install
　　chown -R mysql.mysql /usr/local/mysql/
　　vi /etc/my.cnf
　　[client]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock                 //连接路径
　　[mysql]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock
　　[mysqld]
user = mysql
basedir = /usr/local/mysql                                 //安装根目录
datadir = /usr/local/mysql/data                         //数据库文件存放目录
port = 3306
character_set_server=utf8
pid-file = /usr/local/mysql/mysqld.pid               //进程文件存放位置
socket = /usr/local/mysql/mysql.sock
server-id = 1
　　sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT,ANSI_QUOTES
　　chown mysql:mysql /etc/my.cnf
　　echo 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' >> /etc/profile
echo 'export PATH' >> /etc/profile
source /etc/profile
　　cd /usr/local/mysql/
　　bin/mysqld \
--initialize-insecure \
--user=mysql \
--basedir=/usr/local/mysql \
--datadir=/usr/local/mysql/data
　　cp /usr/local/mysql/usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
systemctl daemon-reload
systemctl start mysqld
netstat -anpt | grep 3306
　　systemctl enable mysqld
　　mysqladmin -u root -p password "abc123" //给root账号设置密码为abc123提示输入的是原始密码。
　　mysql -u root -p
　　------------------------授权远程登录-------------------------------------
grant all privileges on . to 'root'@'%' identified by 'abc123' with grant option;
提升所有权限               某数据库某表@分割符号%任意网段