CentOS 7下RPM方式安装MySQL8

下载地址:https://dev.mysql.com/downloads/mysql/


[root@mysql8 opt]# tar -xvf mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar
mysql-community-libs-8.0.16-2.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.16-2.el7.x86_64.rpm
mysql-community-devel-8.0.16-2.el7.x86_64.rpm
mysql-community-server-8.0.16-2.el7.x86_64.rpm
mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm
mysql-community-client-8.0.16-2.el7.x86_64.rpm
mysql-community-common-8.0.16-2.el7.x86_64.rpm
mysql-community-test-8.0.16-2.el7.x86_64.rpm
[root@mysql8 opt]# ls
mysql-8.0.16-2.el7.x86_64.rpm-bundle.tar        mysql-community-devel-8.0.16-2.el7.x86_64.rpm            mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm  rh
mysql-community-client-8.0.16-2.el7.x86_64.rpm  mysql-community-embedded-compat-8.0.16-2.el7.x86_64.rpm  mysql-community-server-8.0.16-2.el7.x86_64.rpm
mysql-community-common-8.0.16-2.el7.x86_64.rpm  mysql-community-libs-8.0.16-2.el7.x86_64.rpm             mysql-community-test-8.0.16-2.el7.x86_64.rpm
[root@mysql8 opt]# rpm -ivh mysql-community-common-8.0.16-2.el7.x86_64.rpm
warning: mysql-community-common-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-common-8.0.16-2.e################################# [100%]
[root@mysql8 opt]#  rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm
warning: mysql-community-libs-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
        mariadb-libs is obsoleted by mysql-community-libs-8.0.16-2.el7.x86_64
[root@mysql8 opt]# rpm -q mariadb-libs
mariadb-libs-5.5.60-1.el7_5.x86_64
[root@mysql8 opt]# rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64
error: Failed dependencies:
        libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64
        libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64
[root@mysql8 opt]# rpm -ev mariadb-libs-5.5.60-1.el7_5.x86_64
error: Failed dependencies:
        libmysqlclient.so.18()(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64
        libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by (installed) postfix-2:2.10.1-7.el7.x86_64
[root@mysql8 opt]# rpm -e postfix-2:2.10.1-7.el7.x86_64
[root@mysql8 opt]#  rpm -e mariadb-libs-5.5.60-1.el7_5.x86_64
[root@mysql8 opt]# rpm -ivh mysql-community-libs-8.0.16-2.el7.x86_64.rpm
warning: mysql-community-libs-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-libs-8.0.16-2.el7################################# [100%]
[root@mysql8 opt]# rpm -ivh mysql-community-client-8.0.16-2.el7.x86_64.rpm
warning: mysql-community-client-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-client-8.0.16-2.e################################# [100%]
[root@mysql8 opt]#  rpm -ivh mysql-community-server-8.0.16-2.el7.x86_64.rpm
warning: mysql-community-server-8.0.16-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:mysql-community-server-8.0.16-2.e################################# [100%]
[root@mysql8 opt]# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: inactive (dead)
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
[root@mysql8 opt]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
[root@mysql8 opt]# grep password /var/log/mysqld.log
2019-07-14T20:33:00.077696Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 74f1j>pghmvG
[root@mysql8 opt]# mysql -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.16

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

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> SET PASSWORD = 'StrongPass';
Query OK, 0 rows affected (0.01 sec)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
要在 CentOS 上以 RPM 方式离线安装 MySQL 8,请按照以下步骤进行操作: 1. 首先,从 MySQL 官方网站下载 MySQL 8 的离线安装包(RPM 格式)到您的本地机器上。您可以在以下链接中找到适合您操作系统的版本:https://dev.mysql.com/downloads/mysql/ 2. 在您的本地机器上创建一个目录用于安装 MySQL。假设您创建了一个名为 "mysql_install" 的目录。 3. 将下载的 MySQL 8 RPM 安装包复制到 "mysql_install" 目录中。 4. 打开命令行终端,并切换到 "mysql_install" 目录。 5. 安装 MySQL。在命令行中以超级用户身份运行以下命令: ``` sudo rpm -ivh mysql-community-server-8.*.rpm ``` 请将 "mysql-community-server-8.*.rpm" 替换为您下载的实际文件名。 6. 检查安装结果。在命令行中运行以下命令: ``` rpm -qa | grep mysql ``` 如果安装成功,您应该能够看到包含 "mysql-community-server" 的输出。 7. 启动 MySQL 服务器。在命令行中以超级用户身份运行以下命令: ``` sudo systemctl start mysqld ``` 8. 查看 MySQL 服务器状态。在命令行中运行以下命令: ``` sudo systemctl status mysqld ``` 如果 MySQL 服务器已成功启动,您应该能够看到 "active (running)" 的消息。 9. 安装完成后,MySQL 的 root 密码将会被随机生成。您可以使用以下命令查找该密码: ``` sudo grep 'temporary password' /var/log/mysqld.log ``` 您将在输出中找到一个类似于 "A temporary password is generated for root@localhost" 的消息,后面紧跟着的就是生成的临时密码。 10. 使用生成的临时密码登录到 MySQL 服务器,并按照提示更改密码: ``` mysql -u root -p ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; ``` 将 "new_password" 替换为您自定义的新密码。 现在,您已经成功离线安装MySQL 8,并设置了 root 用户的新密码。您可以使用 mysql 命令行工具或其他客户端连接到您的 MySQL 数据库。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值