CentOS7 安装Mysql5.7.20

安装mysql 5.7.20

首先先安装编译工具

yum -y install \

ncurses \

ncurses-devel \

bison \

cmake

 

useradd -s /sbin/nologin  mysql

创建一个mysql用户，指定他不能登录系统

tar xf mysql-boost-5.7.20.tar.gz //压缩mysql数据包

cd mysql-5.7.20/

 

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=boost \

-DWITH_SYSTEMD=1

 

make -j 4 && make install

开始编译和编译安装 -j 4 是使用4个cpu来跑，比较快一点

 

chown -R mysql.mysql /usr/local/mysql/   //递归更改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/lib/systemd/system/mysqld.service /usr/lib/systemd/system/

systemctl daemon-reload

systemctl start mysqld

netstat -anpt | grep 3306 

查询一下Mysql有没有开启

把他加入服务管理

mysqladmin -u root -p password "abc123"  //给root账号设置密码

 

mysql -uroot -pabc123   //登录mysql

 

 

链接：https://pan.baidu.com/s/1gb6mXakpVDkEeQE_AmguSQ
提取码：llxx
复制这段内容后打开百度网盘手机App，操作更方便哦

上面的提取码是Mysql5.7.20