mysql官网二进制包,mysql 二进制包安装

sudo apt install make cmake gcc g++ perl bison libaio-dev libncurses5 libncurses5-dev libnuma-dev

2.mysql源码获取

版本：5.7.17

地址：https://dev.mysql.com/downloads/mysql/

选项：Source Code --> Generic Linux (Architecture Independent) -->mysql-5.7.17.tar.gz

3.解压获取源代码

tar xzvf mysql-5.7.17.tar.gz

cd mysql-5.7.17

tar xzvf boost_1_59_0.tar.gz

cd boost_1_59_0

sudo ./bootstrap.sh

sudo ./b2 install

5.编译安装mysql

cd mysql-5.7.17

cmake . -DBUILD_CONFIG=mysql_release -DCPACK_MONOLITHIC_INSTALL=ON -DCMAKE_INSTALL_PREFIX=/usr/opt/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQLX_TCP_PORT=33060 -DMYSQL_UNIX_ADDR=/usr/opt/mysql/mysql.sock -DMYSQL_TCP_PORT=3306 -DMYSQLX_UNIX_ADDR=/usr/opt/mysql/mysqlx.sock -DMYSQL_DATADIR=/usr/opt/mysql/data -DSYSCONFDIR=/usr/opt/mysql/etc -DENABLE_DOWNLOADS=ON -DWITH_BOOST=system

sudo make

sudo make install

6.初始化设置mysql

sudo groupadd mysql

sudo useradd -r -g mysql -s /bin/false mysql

#更改mysql目录权限

cd /usr/local/mysql

sudo chown -R mysql .

sudo chgrp -R mysql .

#初始化mysql,生成root用户的临时密码,如root@localhost: sL3>%PEjt-ir

sudo bin/mysqld --initialize --user=mysql

#开启SSL功能

sudo bin/mysql_ssl_rsa_setup

#更改mysql目录权限

sudo chown -R mysql .

sudo chgrp -R mysql .

7.测试启动mysql

sudo bin/mysqld_safe --user=mysql

8.启动mysql,输入临时密码后更改密码,停止mysql

sudo support-files/mysql.server start

sudo bin/mysql -u root -p

alter user 'root'@'localhost' identified by 'root';

sudo support-files/mysql.server stop

9.将mysql服务放置init.d目录下

sudo cp support-files/mysql.server /etc/init.d/mysql.server

service控制mysql服务

service mysql.server start|stop|restart|reload|force-reload|status