CentOS 7 安装 MySQL 5.7.25

安装依赖包

yum install libaio

创建mysql用户组

groupadd mysql
useradd -g mysql mysql -d /home/mysql
passwd mysql

创建目录

su mysql
cd /home/mysql
mkdir data
mkdir log
mkdir tmp
mkdir mariadb
cd log
mkdir mariadb

下载安装包

nohup wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz 1>/var/log/mysql_1.log &

安装

cd /usr/local
tar zxvf /mnt/mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.25-linux-glibc2.12-x86_64 mysql
chown -R mysql:mysql mysql/

设置环境变量

vi /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile

配置
/etc/my.cnf

[mysqld]
datadir=/home/mysql/data
socket=/home/mysql/mysql.sock
user=mysql

[mysqld_safe]
log-error=/home/mysql/log/mariadb/mariadb.log
pid-file=/home/mysql/mariadb/mariadb.pid

初始化

bin/mysqld --initialize --user=mysql
2019-03-16T08:30:26.142144Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: bfaced1a-47c5-11e9-ae3a-00163e0b2e37.
2019-03-16T08:30:26.144134Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-03-16T08:30:26.144611Z 1 [Note] A temporary password is generated for root@localhost: z3rG2l+%kyk8

启动

nohup mysqld 1>/home/mysql/mysqld.log &

修改密码

mysql -uroot -h 127.0.0.1 -p
set password for root@localhost=password("123456");

允许远程访问

use mysql;
insert into user values('196.128.0.1','root','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'mysql_native_password','*16789','N',NULL,NULL,'N');
flush privileges;