centos7中mysql5.7的编译安装

• 软件安装包

boost_1_59_0.tar.gz

mysql-5.7.25.tar.gz

• yum源安装所需依赖包

yum install -y gcc-c++ cmake ncurses ncurses-devel

• 解压boost，并移动到/usr/local/boost/

tar -zxvf  boost_1_59_0.tar.gz

mv boost_1_59_0 /usr/local/boost

• 建立用户组合用户

groupadd mysql 

useradd -s /sbin/nologin -g mysql -M mysql

• 建立安装目录和数据库目录

mkdir -p /usr/local/mysql/data

• 解压mysql安装包

tar -zxvf mysql-5.7.25.tar.gz

• 进入解压目录并使用cmake预编译

cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DMYSQL_DATADIR=/usr/local/mysql/data \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DDOWNLOAD_BOOST=1 \
-DWITH_BOOST=/usr/local/boost \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1

• 使用make和make install进行编译安装

make

make install

• 编辑/etc/my.cnf文件，修改成如下内容：

[mysql]
default-character-set=utf8
[mysqld]
port = 3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data/
character-set-server=utf8
default-storage-engine=INNODB

• 修改 /usr/local/mysql目录所属用户和组

chown -Rf mysql:mysql /usr/local/mysql

• 初始化数据库

./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

• 把数据库服务添加到系统中

cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig --level 2345 mysqld on

• 启动数据库

systemctl start mysqld

• 修改密码

mysql -u root -p

[输入密码]

alter user root@localhost identified by 'root';

update mysql.user set host='%' where user='root';

flush privileges;

exit

至此安装完成