CentOS使用yum命令安装mysql8.0

刺骨的言语ヽ痛彻心扉 2023-09-27 10:21 6阅读 0赞

## CentOS使用yum命令安装mysql8.0 ##

# 1.删除已安装的mysql #

**检查MariaDB**

如不存在直接跳过

# rpm -qa|grep mariadb

如果有直接在指定文件夹下删除文件

# rm -rf mariadb

检查是否删除

# rpm -qa|grep mariadb

**检查MySQL**

rpm -qa|grep mysql

如果有安装指定文件夹删除文件

# 2.命令安装 #

## 1.配置Mysql8.0安装源 ##

rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm

安装结果确认

[root@localhost mysql]# rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
    Retrieving https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
    warning: /var/tmp/rpm-tmp.GGzXQR: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
    Preparing...                          ################################# [100%]
    Updating / installing...
       1:mysql80-community-release-el7-1  ################################# [100%]

## 2.装Mysql 8.0 ##

sudo yum install mysql-server --nogpgcheck

## 3.下载中确认选中y ##

## 4.启动mysql服务 ##

service mysqld start

安装结果确认

Complete!
    [root@localhost mysql]# service mysqld start
    Redirecting to /bin/systemctl start mysqld.service

## 5.查看运行状态 ##

service mysqld status

[root@localhost mysql]# 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: active (running) since 六 2022-09-17 08:10:06 EDT; 11s ago
         Docs: man:mysqld(8)
               http://dev.mysql.com/doc/refman/en/using-systemd.html
      Process: 5306 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
     Main PID: 5379 (mysqld)
       Status: "Server is operational"
       CGroup: /system.slice/mysqld.service
               └─5379 /usr/sbin/mysqld

# 3.修改mysql密码 #

1.查看初始密码

grep 'temporary password' /var/log/mysqld.log

2.修改默认密码

mysql -uroot -p复制刚才查看的密码登入

3.更改密码

（如果想简单设置密码，需要将文件进行修改。如果已经设置复杂密码，4请跳过）

alter user 'root'@'localhost' identified by 'MYsql123/*';

4.对临时密码进行修改

\-1validate\_password.length 是密码的最小长度，默认是8，我们把它改成4

set global validate_password.length=4;

\-2validate\_password.policy 验证密码的复杂程度，我们把它改成0

set global validate_password.policy=0;

\-3validate\_password.check\_user\_name 用户名检查，用户名和密码不能相同，我们也把它去掉

set global validate_password.check_user_name=off;

现在再执行修改密码的命令：

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';

# 4.允许root远程访问mysql #

USE mysql;
    CREATE USER 'root'@'localhost' IDENTIFIED BY '你的密码';
    GRANT ALL ON *.* TO 'root'@'localhost';
    FLUSH PRIVILEGES;

# 5.测试远程连接 #

使用SQLyog或者Navicat，运程连接！

![在这里插入图片描述][6a557a01a920421eb79995bbb1c00b3e.png_pic_center]  
![在这里插入图片描述][711b724876a14dbfb3a3598873dcea85.png_pic_center]

[6a557a01a920421eb79995bbb1c00b3e.png_pic_center]: https://img-blog.csdnimg.cn/6a557a01a920421eb79995bbb1c00b3e.png#pic_center
[711b724876a14dbfb3a3598873dcea85.png_pic_center]: https://img-blog.csdnimg.cn/711b724876a14dbfb3a3598873dcea85.png#pic_center