rpm安装mysql

超、凢脫俗 2022-04-16 00:24 360阅读 0赞

1，检查是否已安装mysql

  1. rpm -qa |  grep mysql

已安装mysql，卸载mysql

  1. yum -y remove mysql-libs*

2，在MySQL官网下载mysql安装包

  1. wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar

3，解压

  1. [root@ecs-7bc6-0001 package]# tar -xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar 
  2. mysql-community-libs-5.7.22-1.el7.x86_64.rpm
  3. mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
  4. mysql-community-embedded-5.7.22-1.el7.x86_64.rpm
  5. mysql-community-test-5.7.22-1.el7.x86_64.rpm
  6. mysql-community-server-5.7.22-1.el7.x86_64.rpm
  7. mysql-community-client-5.7.22-1.el7.x86_64.rpm
  8. mysql-community-server-minimal-5.7.22-1.el7.x86_64.rpm
  9. mysql-community-devel-5.7.22-1.el7.x86_64.rpm
  10. mysql-community-common-5.7.22-1.el7.x86_64.rpm
  11. mysql-community-minimal-debuginfo-5.7.22-1.el7.x86_64.rpm
  12. mysql-community-embedded-devel-5.7.22-1.el7.x86_64.rpm
  13. mysql-community-embedded-compat-5.7.22-1.el7.x86_64.rpm

4，查看安装包

  1. [root@ecs-7bc6-0001 package]# ll
  2. total 1168032
  3. -rw-r--r-- 1 root root  598026240 Nov 14 17:32 mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar
  4. -rw-r--r-- 1 7155 31415  25106088 Mar  5  2018 mysql-community-client-5.7.22-1.el7.x86_64.rpm
  5. -rw-r--r-- 1 7155 31415    280800 Mar  5  2018 mysql-community-common-5.7.22-1.el7.x86_64.rpm
  6. -rw-r--r-- 1 7155 31415   3781636 Mar  5  2018 mysql-community-devel-5.7.22-1.el7.x86_64.rpm
  7. -rw-r--r-- 1 7155 31415  46742952 Mar  5  2018 mysql-community-embedded-5.7.22-1.el7.x86_64.rpm
  8. -rw-r--r-- 1 7155 31415  24078476 Mar  5  2018 mysql-community-embedded-compat-5.7.22-1.el7.x86_64.rpm
  9. -rw-r--r-- 1 7155 31415 129955496 Mar  5  2018 mysql-community-embedded-devel-5.7.22-1.el7.x86_64.rpm
  10. -rw-r--r-- 1 7155 31415   2239868 Mar  5  2018 mysql-community-libs-5.7.22-1.el7.x86_64.rpm
  11. -rw-r--r-- 1 7155 31415   2116356 Mar  5  2018 mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
  12. -rw-r--r-- 1 7155 31415  55743828 Mar  5  2018 mysql-community-minimal-debuginfo-5.7.22-1.el7.x86_64.rpm
  13. -rw-r--r-- 1 7155 31415 172992596 Mar  5  2018 mysql-community-server-5.7.22-1.el7.x86_64.rpm
  14. -rw-r--r-- 1 7155 31415  15255560 Mar  5  2018 mysql-community-server-minimal-5.7.22-1.el7.x86_64.rpm
  15. -rw-r--r-- 1 7155 31415 119716756 Mar  5  2018 mysql-community-test-5.7.22-1.el7.x86_64.rpm

5,安装mysql，依次执行

  1. rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm
  2. rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm
  3. rpm -ivh mysql-community-client-5.7.22-1.el7.x86_64.rpm
  4. rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm

执行期间报错时，需要删除已经安装的mariadb,如下

  1. [root@ecs-7bc6-0001 package]# rpm -ivh mysql-community-libs-5.7.22-1.el7.x86_64.rpm 
  2. warning: mysql-community-libs-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
  3. error: Failed dependencies:
  4.     mysql-community-common(x86-64) >= 5.7.9 is needed by mysql-community-libs-5.7.22-1.el7.x86_64
  5.     mariadb-libs is obsoleted by mysql-community-libs-5.7.22-1.el7.x86_64
  6. [root@ecs-7bc6-0001 package]# 
  7. [root@ecs-7bc6-0001 package]# 
  8. [root@ecs-7bc6-0001 package]# yum list installed |grep mariadb 
  9. mariadb-libs.x86_64                     1:5.5.56-2.el7             
  10. [root@ecs-7bc6-0001 package]# yum -y remove mariadb-libs.x86_64

执行期间保存，需要安装依赖libaio

  1. [root@ecs-7bc6-0001 package]# rpm -ivh mysql-community-server-5.7.22-1.el7.x86_64.rpm 
  2. warning: mysql-community-server-5.7.22-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
  3. error: Failed dependencies:
  4.     libaio.so.1()(64bit) is needed by mysql-community-server-5.7.22-1.el7.x86_64
  5.     libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-5.7.22-1.el7.x86_64
  6.     libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-5.7.22-1.el7.x86_64
  7. [root@ecs-7bc6-0001 package]# 
  8. [root@ecs-7bc6-0001 package]# 
  9. [root@ecs-7bc6-0001 package]# yum install libaio

6,数据库初始化

  1. [root@ecs-7bc6-0001 package]# mysqld --initialize --user=mysql

--user指定以mysql用户运行mysqlserver

7，查看root密码

  1. [root@ecs-7bc6-0001 package]# grep password /var/log/mysqld.log
  2. 2018-11-14T10:04:35.338847Z 1 [Note] A temporary password is generated for root@localhost: ?h4G(>t!xYE8

8，启动，停止，重启mysqlserver

  1. [root@ecs-7bc6-0001 package]# service mysqld stop
  2. Redirecting to /bin/systemctl stop mysqld.service
  3. [root@ecs-7bc6-0001 package]# service mysqld start
  4. Redirecting to /bin/systemctl start mysqld.service
  5. [root@ecs-7bc6-0001 package]# service mysqld restart
  6. Redirecting to /bin/systemctl restart mysqld.service

9，登录mysql客户端

  1. [root@ecs-7bc6-0001 package]# mysql -uroot -p
  2. Enter password: 
  3. Welcome to the MySQL monitor.  Commands end with ; or \g.
  4. Your MySQL connection id is 2
  5. Server version: 5.7.22
  7. Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

10，修改密码

  1. mysql> alter user 'root'@'localhost' identified by "ceshimima";
  2. Query OK, 0 rows affected (0.00 sec)
  4. mysql> flush privileges;
  5. Query OK, 0 rows affected (0.00 sec)

11,设置开机启动

  1. [root@ecs-7bc6-0001 package]# chkconfig mysqld
  2. Note: Forwarding request to 'systemctl is-enabled mysqld.service'.
  3. enabled

恭喜你安装完成(^_^)

发表评论

表情：
评论列表 （有 0 条评论，360人围观）

还没有评论，来说两句吧...

相关阅读

    相关 rpm包安装mysql

    如何用源码包安装MySQL数据库 下载源码，里面安装说明，一般都是./configure。。。。。。makeinstall，安装起来很慢 本回答由提问者推荐 如何用

    我不是女神ヾ我不是女神ヾ/ 0 赞/ 141 阅读

    相关 rpm安装mysql

    引言     之前安装mysql都是直接使用tar包安装，没有用过rpm，今天搞了一台腾讯云服务器，所以想尝试一种新的安装mysql的方式，下面分享安装过程和遇到的问题。

    朱雀朱雀/ 0 赞/ 89 阅读

    相关 mysql gtid rpm安装

    注意: 负责在主、从服务器传输各种修改动作的媒介是主服务器的二进制变更日志，这个日志记载着需要传输给从服务器的各种修改动作。因此，主服务器必须激活二进制日志功能。从服务器必须

    怼烎@怼烎@/ 0 赞/ 255 阅读