centos7安装mysql 8.0

1.节点信息

192.168.0.205

2.关闭防火墙

[root@MESDB-205 ~]# systemctl disable firewalld&&systemctl stop firewalld&&systemctl daemon-reload

3.时间同步

[root@MESDB-205 ~]# yum install chrony -y
[root@MESDB-205 ~]# systemctl enable chronyd
[root@MESDB-205 ~]# systemctl start chronyd
[root@MESDB-205 ~]# chronyc sources

4.安装mysql

1.卸载默认的mariadb

yum remove mariadb.x86_64

2.去官网找mysql的下载版本

https://dev.mysql.com/downloads/repo/yum/

https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm

3.安装yum 源

下载
[root@MESDB-205 mysql]# pwd
/home/mysql
[root@MESDB-205 mysql]#wget https://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm

本地安装mysql yum 源
[root@MESDB-205 mysql]#yum localinstall mysql

检查yum 源是否已经安装

4.安装mysql

[root@MESDB-205 mysql]# yum install mysql-community-server.x86_64

检查是否已经安装成功
[root@MESDB-205 mysql]# ps -ef | grep mysql
root      4217  1725  0 14:25 pts/1    00:00:00 grep --color=auto mysql

启动mysql
[root@MESDB-205 mysql]# systemctl enable mysqld
[root@MESDB-205 mysql]# systemctl start mysqld
[root@MESDB-205 mysql]# systemctl status mysqld

5.修改默认密码

查找默认密码
[root@MESDB-205 mysql]# cat /var/log/mysqld.log | grep password
2022-10-21T05:42:50.954569Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 5>to(LQESxXi

登陆，使用  5>to(LQESxXi   这个密码登录
mysql -uroot -p

修改root密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '5to#LQESxXi';
Query OK, 0 rows affected (0.00 sec)

6.开通远程连接权限

[root@MESDB-205 mysql]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16
 
mysql> select host, user from user \G;
*************************** 1. row ***************************
host: localhost
user: mysql.infoschema
*************************** 2. row ***************************
host: localhost
user: mysql.session
*************************** 3. row ***************************
host: localhost
user: mysql.sys
*************************** 4. row ***************************
host: localhost
user: root
4 rows in set (0.00 sec)
 
ERROR: 
No query specified

 开启权限
mysql> update user set host="%" where Host='localhost' and user = "root";
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
 
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
 

检查下
mysql> select host, user from user \G;
*************************** 1. row ***************************
host: %
user: root
*************************** 2. row ***************************
host: localhost
user: mysql.infoschema
*************************** 3. row ***************************
host: localhost
user: mysql.session
*************************** 4. row ***************************
host: localhost
user: mysql.sys
4 rows in set (0.00 sec)
 
ERROR: 
No query specified
 
mysql> 

7.关键目录