Redhat 8.7 安装Mysql 8.0.34步骤（超级详细）

最新推荐文章于 2024-01-18 17:47:43 发布

吐蕃-鸠摩智

最新推荐文章于 2024-01-18 17:47:43 发布

阅读量2.4k

点赞数 4

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： mysql 数据库

本文链接：https://blog.csdn.net/zhiqianghan/article/details/132232179

数据库专栏收录该内容

7 篇文章

订阅专栏

本文详细介绍了如何在RedHatEnterpriseLinux8.7上下载并安装MySQLYumRepository，禁用默认MySQL模块，设置临时密码，以及允许远程登录。过程包括查看系统版本、安装社区版MySQL服务器、启用系统服务和管理用户权限。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

查看Redhat 版本

[root@node1-221 ~]# cat /etc/redhat-release 
Red Hat Enterprise Linux release 8.7 (Ootpa)

下载MySQL Yum Repository

下载MySQL源官网地址：https://dev.mysql.com/downloads/repo/yum/
根据系统版本选择下载相应的MySQL Yum源
在这里插入图片描述

安装mysql

[root@node1-221 ~]# yum install mysql80-community-release-el8-7.noarch.rpm

[root@node1-221 ~]# yum repolist
Updating Subscription Management repositories.
Unable to read consumer identity

This system is not registered with an entitlement server. You can use subscription-manager to register.

repo id                                                                                         repo name
appstream                                                                                       appstream
baseos                                                                                          baseos
mysql-connectors-community                                                                      MySQL Connectors Community
mysql-tools-community                                                                           MySQL Tools Community
mysql80-community                                                                               MySQL 8.0 Community Server
[root@node1-221 ~]# yum repolist| grep mysql
mysql-connectors-community              MySQL Connectors Community
mysql-tools-community                   MySQL Tools Community
mysql80-community                       MySQL 8.0 Community Server

Disabling the Default MySQL Module

(EL8 systems only) EL8-based systems such as RHEL8 and Oracle Linux 8 include a MySQL module that is enabled by default. Unless this module is disabled, it masks packages provided by MySQL repositories. To disable the included module and make the MySQL repository packages visible, use the following command (for dnf-enabled systems, replace yum in the command with dnf):
EL8系统，需要禁掉默认的MySQL仓库

[root@node1-221 ~]# yum module disable mysql

安装MySQL

[root@node1-221 ~]# yum install mysql-community-server

启动MySQL

[root@node1-221 ~]# systemctl start mysqld
[root@node1-221 ~]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2023-08-11 14:44:16 CST; 1s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 14401 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 14473 (mysqld)
   Status: "Server is operational"
    Tasks: 38 (limit: 24850)
   Memory: 454.2M
   CGroup: /system.slice/mysqld.service
           └─14473 /usr/sbin/mysqld

Aug 11 14:44:10 node1-221 systemd[1]: Starting MySQL Server...
Aug 11 14:44:16 node1-221 systemd[1]: Started MySQL Server.

查看MySQL临时密码

通过日志文件MySQL初始密码
MySQL的临时密码存放在/var/log/mysqld.log文件下

[root@node1-221 ~]# grep 'temporary password' /var/log/mysqld.log
2023-08-11T06:44:12.606853Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Ig3PKBN3z.36

进入MySQL，修改临时密码

[root@node1-221 ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.34

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> alter user 'root'@'localhost' identified by 'Lab123!@#';
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

使用新密码登陆MySQL

[root@node1-221 ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 8.0.34 MySQL Community Server - GPL

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

通过客户端登陆，不成功
在这里插入图片描述


mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select host,user from user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| localhost | mysql.infoschema |
| localhost | mysql.session    |
| localhost | mysql.sys        |
| localhost | root             |
+-----------+------------------+
4 rows in set (0.00 sec)

mysql> update user set host='%' where user='root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)