centos安装mysql5.7

古城微笑少年丶 2024-04-21 19:23 3阅读 0赞

**一、使用yum源方式安装**

1.卸载系统自带 mariadb，CentOS 7 中默认安装有 MariaDB安装完直接把它覆盖掉就可以

[root@localhost /]# rpm -qa|grep mariadb
    mariadb-libs-5.5.68-1.el7.x86_64
    [root@localhost /]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
    [root@localhost /]# rpm -qa|grep mariadb

**2.下载安装官方yum**

CentOS7 的yum源中没有mysql，需要到mysql的官网去下载yum repo配置文件

# wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
    
    # ls

**3.安装mysql的yum源**

> 执行完成后会在 /etc/yum.repos.d/ 目录下生成两个repo文件
> 
> mysql-community.repo
> 
> mysql-community-source.repo

[root@localhost ~]# yum -y install mysql57-community-release-el7-11.noarch.rpm

看一看是否出现上边那两个文件

[root@localhost ~]# ls /etc/yum.repos.d/

**4.yum安装mysql**

[root@localhost ~]# yum -y install mysql-server

5.安装过程中报错解决，上一步如果报错就执行以下代码，如果没有报错忽略！

运行命令
    [root@localhost ~]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
    重新安装
    [root@localhost ~]# yum -y install mysql-server

**6.启动mysql查看状态**

[root@localhost ~]# systemctl start mysqld.service
    [root@localhost ~]# systemctl status mysqld.service

**7.获取临时密码（mysql在安装时候默认生成随机密码）**

[root@localhost ~]# cat /var/log/mysqld.log | grep password
    2023-02-25T12:00:58.723624Z 1 [Note] A temporary password is generated for root@localhost: qwe21616615=

这个地方我的随机密码是：qwe21616615=

**8.登录mysql，输入刚才的临时密码**

[root@localhost ~]# mysql -u root -p
    Enter password:

**9.修改密码**

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Wxq3012@';
    Query OK, 0 rows affected (0.00 sec)

**10.开启远程访问权限，因为后续要操作数据库，记得在云服务器上开放3306端口**

mysql> grant all privileges on *.* to 'root'@'%' identified by 'Wxq3012@' with grant option;
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    mysql> flush privileges;
    Query OK, 0 rows affected (0.00 sec)

大功告成！！！