MySQL5.7.19编译安装教程

mysql 版本 5.7.19

必备的包和工具

gcc/g++ ：MySQL 5.6开始，需要使用g++进行编译。

bison ：MySQL语法解析器需要使用bison进行编译。

libncurses5-dev ：用于终端操作的开发包.(注：Debian/Ubuntu下需要安装libncurses5-dev;Redhat下需要安装 ncurses-devel)

zlib ：MySQL使用zlib进行压缩

功能需要的包

libxml2 ：用于XML输入输出方式的支持。

openssl ：使用openssl安全套接字方式通信。

dtrace ：用于诊断MySQL问题。

cmake ：MySQL 5.5开始，使用cmake进行工程管理，cmake需要2.8以上版本。

sudo apt-get install gcc

sudo apt-get install libxml2

sudo apt-get install libncurses5-dev bison

安装cmake 下载地址 https://cmake.org/download/

建立源码包目录

mkdir /data/src

解压

tar zxvf cmake-3.6.1.tar.gz

mv cmake-3.6.1 /data/src

cd cmake-3.6.1

编译安装

./configure make && make install

加入环境变量

vim ~/.bashrc

添加

export PATH="/data/src/cmake-3.6.1/bin/cmake:$PATH"

从MySQL 5.7.5开始Boost库是必需的，下载Boost库 https://sourceforge.net/projects/boost/files/boost/

tar zxvf boost_1_59_0.tar.gz

mv boost_1_59_0 /data/src/

mysql官方下载地址

https://dev.mysql.com/downloads/mysql/ 此次有个坑：一定要选择选择可编译版本

具体过程如下：

tar -zxvf mysql-5.7.19.tar.gz
cd /data/
mkdir service
cd /
ll
cd /data/
mkdir src
cd /src/
cp -r /mysql-5.7.19 /data/src/
cd /data/src/
pkill -9 mysqld
cd mysql-5.7.19/


cmake -DCMAKE_INSTALL_PREFIX=/data/service/mysql -


DMYSQL_UNIX_ADDR=/data/service/mysql/data/mysql.sock -DDEFAULT_CHARSET=utf8 -


DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS:STRING=utf8,gbk -


DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MEMORY_STORAGE_ENGINE=1 


-DWITH_READLINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/data/service/mysql/data -


DMYSQL_USER=mysql -DMYSQL_TCP_PORT=3306 -DDOWNLOAD_BOOST=1 -


DWITH_BOOST=/data/service/mysql/mysql-5.7.19/boost/boost_1_59_0


make & make install
cd /data/service
ll
cd mysql
ll
mkdir etc
cd etc/
cp /etc/init.d/my.cnf ./
ls
cd ../
./bin/mysqld --defaults-file=/data/service/mysql/etc/my.cnf --initialize --user=mysql
./bin/my
./bin/mysql -uroot -p
cd /data/service/mysql/
ll
cd /data
ls
ps -ef|grep mysql
cd ../
chown -R root .
chown -R mysql mysql
chown -R mysql data/
pkill -9 mysqld
ps -ef|grep mysql
./bin/mysqld_safe --user=mysql &
./bin/mysql -uroot -p
ps -ef|grep mysql
vi etc/my.cnf
vi /etc/init.d/my.cnf
cp /data/service/mysql/support-files/mysql.server /etc/init.d/
vi /etc/init.d/mysql.server
/etc/init.d/mysql.server restart
./bin/mysqld_safe --user=mysql
ps -ef|grep mysql
./bin/mysql -uroot -p
set password = password('123456');
use mysql;
select * from user \G;
update user set authentication_string=password('123456') where user='root' and host=
flush privileges;
 exit
 vi /etc/init.d/my.cnf
 /etc/init.d/mysql.server restart
./bin/mysql -uroot -p
exit
vi /etc/init.d/my.cnf






//忘记密码时：mysql设置：
1.首先修改配置文件：/etc/init.d/my.cnf
把skip-grant-tables注释打开！顾名思义,就是在启动mysql时不启动grant-tables,授权表
2../bin/mysql -uroot -p
set password = password('123456');
use mysql;
select * from user \G;
update user set authentication_string=password('123456') where user='root' and host=
flush privileges;












#/etc/init.d/my.cnf配置如下：
[client]
port = 3306
socket = /data/service/mysql/data/mysql.sock


[mysqld]
port = 3306
socket = /data/service/mysql/data/mysql.sock


basedir = /data/service/mysql
datadir = /data/service/mysql/data
pid-file = /data/service/mysql/data/mysql.pid
user = mysql


server-id = 1
log-bin = mysql-bin


skip-name-resolve
#skip-grant-tables








#etc/my.cnf配置如下：
# For advice on how to change settings please see
# https://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.




[mysqld]
port = 3306
socket = /usr/local/mysql/data/mysql.sock
basedir = /usr/local/mysql
explicit_defaults_for_timestamp=1
datadir  = /usr/local/mysql/data
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M


# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin


# These are commonly set, remove the # and set as required.
# basedir = .....
# datadir = .....
# port = .....
# server_id = .....
# socket = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M


sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES