rpm安装mysql

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

1，检查是否已安装mysql

rpm -qa |  grep mysql

已安装mysql，卸载mysql

yum -y remove mysql-libs*

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

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

3，解压

[root@ecs-7bc6-0001 package]# tar -xvf mysql-5.7.22-1.el7.x86_64.rpm-bundle.tar 
    mysql-community-libs-5.7.22-1.el7.x86_64.rpm
    mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
    mysql-community-embedded-5.7.22-1.el7.x86_64.rpm
    mysql-community-test-5.7.22-1.el7.x86_64.rpm
    mysql-community-server-5.7.22-1.el7.x86_64.rpm
    mysql-community-client-5.7.22-1.el7.x86_64.rpm
    mysql-community-server-minimal-5.7.22-1.el7.x86_64.rpm
    mysql-community-devel-5.7.22-1.el7.x86_64.rpm
    mysql-community-common-5.7.22-1.el7.x86_64.rpm
    mysql-community-minimal-debuginfo-5.7.22-1.el7.x86_64.rpm
    mysql-community-embedded-devel-5.7.22-1.el7.x86_64.rpm
    mysql-community-embedded-compat-5.7.22-1.el7.x86_64.rpm

4，查看安装包

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

`5,安装mysql，依次执行`

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

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

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

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

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

`6,数据库初始化`

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

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

`7，查看root密码`

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

`8，启动，停止，重启mysqlserver`

[root@ecs-7bc6-0001 package]# service mysqld stop
    Redirecting to /bin/systemctl stop mysqld.service
    [root@ecs-7bc6-0001 package]# service mysqld start
    Redirecting to /bin/systemctl start mysqld.service
    [root@ecs-7bc6-0001 package]# service mysqld restart
    Redirecting to /bin/systemctl restart mysqld.service

`9，登录mysql客户端`

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

`10，修改密码`

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

`11,设置开机启动`

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

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