二进制安装mysql centos7.8+mysql5.7

二进制安装mysql数据库
安装依赖包
[root@localhost ~]# yum install -y libaio perl-Data-Dumper
解压二进制包
[root@localhost src]# tar xfv mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz
配置主目录软连接
[root@localhost src]# ln -sv /usr/local/src/mysql-5.7.30-linux-glibc2.12-x86_64 /usr/local/m
ysql
创建mysql用户
[root@localhost src]# useradd mysql -s /sbin/nologin
创建数据库目录和库文件目录
[root@localhost src]# mkdir -pv /data/mysql
mkdir: created directory ‘/data/mysql’
[root@localhost src]# mkdir -pv /var/lib/mysql
mkdir: created directory ‘/var/lib/mysql’
修改目录权限
[root@localhost src]# chown -R mysql.mysql /data/
[root@localhost src]# chown -R mysql.mysql /var/lib/mysql
配置环境变量
[root@localhost mysql]# echo 'PATH=/usr/local/mysql/bin:$PATH' > /etc/profile.d/mysql.sh
准备配置文件
[root@localhost mysql]# vim /etc/my.cnf
[mysqld]
#server-id=22
datadir=/data/mysql
skip_name_resolve=1
socket=/data/mysql/mysql.sock
log-error=/data/mysql/mysql.log
pid-file=/data/mysql/mysql.pid
[client]
socket=/data/mysql/mysql.sock
初始化数据库
[root@localhost bin]# mysqld --initialize --user=mysql --datadir=/data/mysql
生成mysql自启动文件
[root@localhost bin]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@localhost bin]# chkconfig --add mysqld
[root@localhost bin]# service mysqld start
Starting MySQL. SUCCESS! 
修改登录密码
#skip-grant-tables
mysql> update mysql.user set authentication_string=password('centos') where user='root';
Query OK, 0 rows affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 0  Warnings: 1
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
创建数据库及授权
mysql>create database wordpress;
mysql> grant all privileges on wordpress.* to "wordpress"@"10.0.0.%" identified by "123456";
 Query OK, 0 rows affected, 1 warning (0.00 sec
访问测试在另一台客户端上测试
[root@localhost src]# mysql -uwordpress -h10.0.0.17 -p123456
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.30 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| wordpress          |
+--------------------+