CentOS7安装MYSQL8.X的教程详解

1

# rpm -qa|grep mysql

1

# yum -y install wget

1

# rpm -qa|grep mariadb

1

# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

1

# wget http://mirrors.aliyun.com/repo/Centos-7.repo

1

2

3

# yum clean all    --清除yum

# yum makecache    --清除缓存

# yum repolist     --查看仓储包

1

2

# cd /tmp/

# rm -rf *

1

wget https://dev.mysql.com/get/Downloads/mysql-community-server-8.0.27-1.el7.x86_64.rpm

1

# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

1

# sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm

1

2

# cd /etc/yum.repos.d/

# ls -l

1

# yum install -y  mysql-community-server

1

2

# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

# yum install -y  mysql-community-server

1

2

3

# vi /etc/my.cnf 

#跳过名称解析，提高数据库的连接速度

# skip-name-resolve

1

2

3

# systemctl start mysqld        --启动mysql服务

# systemctl status mysqld       --查看mysql服务状态

# netstat  -nlpt | grep mysqld  --查看端口

1

2

# systemctl enable mysqld

# systemctl daemon-reload

1

# cat /var/log/mysqld.log  | grep password

1

mysql  -uroot  -p

1

2

3

mysql> alter user 'root'@'localhost'  identified by 'Root123..';  --修改密码（强密码）

mysql> flush privileges;                                          --刷新，立即生效

mysql> select user,host from mysql.user;                          --查看数据库中账号信息

1

2

3

mysql> set global validate_password.policy=0; --关掉强密码认证

mysql> set global validate_password.length=6; --密码长度最短为6位数

mysql> alter user 'root'@'localhost'  identified by '123456';  --修改密码（弱密码）

1

2

3

# firewall-cmd --zone=public --add-port=3306/tcp --permanent --开放3306端口

# firewall-cmd --reload                                      --重启防火墙

# firewall-cmd --list-ports                                  --查看开放的端口

1

2

3

4

5

6

# mysql -uroot -p123456                            --登录数据库

mysql> show databases;                             --查数据来库

mysql> use mysql;                                  --使用数据库

mysql> select Host, User from user;                --查询表

mysql> update user set Host='%' where User='root'; --修改User表内root用户的Host为%

mysql> flush privileges;                           --刷新

1

2

3

4

mysql> create database  test_data;                                          --创建一个数据库

mysql>  create user admin@'%' identified  by 'Admin@123..';                --创建一个新的用户 admin 密码 Admin@123..

mysql> grant all privileges on test_data.* to admin@'%' with grant option; --授权，给test_data库的所有权限

mysql> flush privileges;                                                   --刷新

1

2

3

mysql> create user test identified by '123456';

mysql> grant all privileges on *.* to 'admin'@'%'identified by '123456' with grant option;

mysql> flush privileges ;

1

2

3

mysql> create user test@'%' identified  by '123456';

mysql> grant all privileges on *.* to admin@'%' with grant option;

mysql> flush privileges;