MySQL redhat7 安装mysql8

╰+攻爆jí腚メ 2022-05-23 04:10 288阅读 0赞

vmware 装个 Redhat7 然后再装个mysql、  
系统版本：rhel-server-7.4-x86\_64  
软件版本： mysql-8.0.11-1.el7.x86\_64

系统自己找、  
mysql下载地址：https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-1.el7.x86\_64.rpm-bundle.tar

--------------------

## 安装系统： ##

需要注意的是：  
如果需要安装图形化界面、在软件选择中要先选择带GUI的服务器  
![这里写图片描述][70]

--------------------

## 安装mysql： ##

创建用户：  
groupadd mysql  
useradd -g mysql mysql  
passwd mysql

创建文件夹：  
mkdir /mysql  
chown mysql:mysql /mysql

上传mysql rpm包  
解压mysql rpm包：  
tar -xf mysql-8.0.11-1.el7.x86\_64.rpm-bundle.tar  
解压后文件为：

-rwxrwxrwx. 1 mysql mysql  26760484 4月   9 01:06 mysql-community-client-8.0.11-1.el7.x86_64.rpm
    -rwxrwxrwx. 1 mysql mysql    549512 4月   9 01:06 mysql-community-common-8.0.11-1.el7.x86_64.rpm
    -rwxrwxrwx. 1 mysql mysql   4221784 4月   9 01:06 mysql-community-devel-8.0.11-1.el7.x86_64.rpm
    -rwxrwxrwx. 1 mysql mysql  24343708 4月   9 01:06 mysql-community-embedded-compat-8.0.11-1.el7.x86_64.rpm
    -rwxrwxrwx. 1 mysql mysql   2349488 4月   9 01:06 mysql-community-libs-8.0.11-1.el7.x86_64.rpm
    -rwxrwxrwx. 1 mysql mysql   2156516 4月   9 01:06 mysql-community-libs-compat-8.0.11-1.el7.x86_64.rpm
    -rwxrwxrwx. 1 mysql mysql 119957152 4月   9 01:06 mysql-community-minimal-debuginfo-8.0.11-1.el7.x86_64.rpm
    -rwxrwxrwx. 1 mysql mysql 357581528 4月   9 01:07 mysql-community-server-8.0.11-1.el7.x86_64.rpm
    -rwxrwxrwx. 1 mysql mysql  20562556 4月   9 01:07 mysql-community-server-minimal-8.0.11-1.el7.x86_64.rpm
    -rwxrwxrwx. 1 mysql mysql  45494324 4月   9 01:07 mysql-community-test-8.0.11-1.el7.x86_64.rpm

开始安装：

由于系统中存在mariadb 包会导致 mysql安装时报错mariadb-libs 被 mysql-community-libs-8.0.11-1.el7.x86\_64 取代  
卸载mariadb 包：  
yum remove mariadb\*

卸载完成后开始安装mysql  
有顺序：

[root@mysql mysql-rpm]# rpm -ivh mysql-community-common-8.0.11-1.el7.x86_64.rpm 
    警告：mysql-community-common-8.0.11-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
    准备中...                          ################################# [100%]
    正在升级/安装...
       1:mysql-community-common-8.0.11-1.e################################# [100%]
    [root@mysql mysql-rpm]# rpm -ivh mysql-community-libs-
    mysql-community-libs-8.0.11-1.el7.x86_64.rpm
    mysql-community-libs-compat-8.0.11-1.el7.x86_64.rpm
    [root@mysql mysql-rpm]# rpm -ivh mysql-community-libs-8.0.11-1.el7.x86_64.rpm 
    警告：mysql-community-libs-8.0.11-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
    准备中...                          ################################# [100%]
    正在升级/安装...
       1:mysql-community-libs-8.0.11-1.el7################################# [100%]
    [root@mysql mysql-rpm]# rpm -ivh mysql-community-client-8.0.11-1.el7.x86_64.rpm 
    警告：mysql-community-client-8.0.11-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
    准备中...                          ################################# [100%]
    正在升级/安装...
       1:mysql-community-client-8.0.11-1.e################################# [100%]
    [root@mysql mysql-rpm]# rpm -ivh mysql-community-server-8.0.11-1.el7.x86_64.rpm 
    警告：mysql-community-server-8.0.11-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
    准备中...                          ################################# [100%]
    正在升级/安装...
       1:mysql-community-server-8.0.11-1.e#####                             ( 16%)                                    ################################# [100%]

安装完成后初始化mysql数据库：

[root@mysql etc]# mysqld --initialize --user=mysql

查看初始随机密码：

cat /var/log/mysqld.log
    2018-06-01T15:06:49.353471Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.11) initializing of server in progress as process 7940
    2018-06-01T15:06:52.297427Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: rc6;6ghVosk;
    2018-06-01T15:06:54.301806Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.11) initializing of server has completed

初始密码为rc6;6ghVosk;

开启mysql服务：

[root@mysql etc]#service mysqld start
    Redirecting to /bin/systemctl start mysqld.service

登陆mysql、修改root密码：

[root@mysql etc]# mysql -u root -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 9
    Server version: 8.0.11
    
    Copyright (c) 2000, 2018, 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> alter user 'root'@'localhost'identified by '123456'
        -> ;
    Query OK, 0 rows affected (0.00 sec)

更新

安装rpm包  
yum remove mariadb\*  
yum install libaio

rpm -ivh mysql-community-common-8.0.16-2.el7.x86\_64.rpm  
rpm -ivh mysql-community-libs-8.0.16-2.el7.x86\_64.rpm  
rpm -ivh mysql-community-libs-compat-8.0.16-2.el7.x86\_64.rpm  
rpm -ivh mysql-community-client-8.0.16-2.el7.x86\_64.rpm  
rpm -ivh mysql-community-server-8.0.16-2.el7.x86\_64.rpm  
rpm -ivh mysql-community-embedded-compat-8.0.16-2.el7.x86\_64.rpm  
rpm -ivh mysql-community-test-8.0.16-2.el7.x86\_64.rpm --force --nodeps  
rpm -ivh mysql-community-devel-8.0.16-2.el7.x86\_64.rpm --force --nodeps

初始化数据库  
mysqld --initialize --user=mysql

查看初始密码  
cat /var/log/mysqld.log  
N2k.p;eVBqe\_  
开启MySQL服务  
service mysqld start  
登录数据库修改密码  
mysql -u root -p

alter user USER() identified by ‘Lunz2017’;

[70]: /images/20220523/c8fe38eaf04946ea851b175ed44f4bb6.png