mysql8.0在线安装

#配置MYSQL YUM源
vim /etc/yum.repos.d/mysql.repo

[mysql]
name= mysql8.0
baseurl=https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-x86_64/
enable=1
gpgcheck=0

#清除并缓存YUM数据
yum clean all && yum makecache

#安装MYSQL
yum install -y mysql-community-server

#启动MYSQL服务
systemctl enable --now mysqld
systemctl enable mysqld

#查询mysql密码
grep “password” /var/log/mysqld.log
2023-07-05T08:26:48.865118Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 6DzA*tt#nRna

#登mysql
mysql -uroot -pM&Q5qdA6;fhi

#修改root帐号本地登陆密码
mysql> ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘SZgas@itsm12#$’;
Query OK, 0 rows affected (0.01 sec)

#创建chemex表
mysql> create database chemex;
Query OK, 1 row affected (0.01 sec)

#创建Chemex用户
mysql> create user ‘chemex’@‘%’ identified by ‘SZgas@itsm12#$’;
Query OK, 0 rows affected (0.01 sec)

#添加chemex访问chemex
mysql> grant all privileges on chemex.* to ‘chemex’@‘%’;
Query OK, 0 rows affected (0.00 sec)

#如无远程管理需求可直接退出mysql，进入下一步配置
#以下为MYSQL远程管理连接配置，如不需要使用远程管理可不配置
#因mysql8之前,加密规则是mysql_native_password mysql8之后,加密规则是caching_sha2_password
#升级8.0版本的不会改变现有用户的身份验证方法，但新用户会默认使用新的caching_sha2_password
#所以新安装的mysql8数据库需要手动修改数据库加密规则
#切换用户管理
mysql> use mysql;

#查询帐号权限
mysql> select user,host,plugin,authentication_string from mysql.user;
±-----------------±----------±----------------------±-----------------------------------------------------------------------+
| user | host | plugin | authentication_string |
±-----------------±----------±----------------------±-----------------------------------------------------------------------+
| chemex | % | caching_sha2_password | $A 005 005