CentOS7 yum方式在线安装MySQL5.7及设置密码

悠悠 2023-02-13 05:46 5阅读 0赞

1.之前安装了5.6，先卸载了

[root@chen ~]# rpm -qa|grep -i mysql
    mysql-community-libs-5.6.48-2.el7.x86_64
    mysql-community-release-el7-5.noarch
    mysql-community-common-5.6.48-2.el7.x86_64
    mysql-community-client-5.6.48-2.el7.x86_64
    mysql-community-server-5.6.48-2.el7.x86_64
    [root@chen ~]# systemctl stop mysqld.service
    [root@chen ~]# rpm -ev --nodeps mysql-community-libs-5.6.48-2.el7.x86_64
    Preparing packages...
    mysql-community-libs-5.6.48-2.el7.x86_64
    [root@chen ~]# rpm -ev --nodeps mysql-community-release-el7-5.noarch
    Preparing packages...
    mysql-community-release-el7-5.noarch
    [root@chen ~]# rpm -ev --nodeps mysql-community-common-5.6.48-2.el7.x86_64
    Preparing packages...
    mysql-community-common-5.6.48-2.el7.x86_64
    [root@chen ~]# rpm -ev --nodeps mysql-community-client-5.6.48-2.el7.x86_64
    Preparing packages...
    mysql-community-client-5.6.48-2.el7.x86_64
    [root@chen ~]# rpm -ev --nodeps mysql-community-server-5.6.48-2.el7.x86_64
    Preparing packages...
    mysql-community-server-5.6.48-2.el7.x86_64
    warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave
    [root@chen ~]# rpm -qa|grep -i mysql
    [root@chen ~]#

2.没有wget的，先安装

yum -y install wget

3.下载安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm --no-check-certificate

4.安装mysql源

yum localinstall mysql57-community-release-el7-8.noarch.rpm

5.检查是否安装成功了

yum repolist enabled | grep "mysql.*-community.*"

6.安装mysql并启动

yum install mysql-community-server
    #或者service mysqld start
    systemctl start mysqld 
    #查看状态
    systemctl status mysqld

7.设置开机启动

systemctl enable mysqld
    systemctl daemon-reload

8.获取初始化密码  
如果执行获取命令没拿到，需要删除原来安装的mysql残留数据

[root@chen ~]# grep 'temporary password' /var/log/mysqld.log 
    [root@chen ~]# rm -rf /var/lib/mysql
    [root@chen ~]# systemctl restart mysqld
    [root@chen ~]# grep 'temporary password' /var/log/mysqld.log
    2019-08-07T19:16:44.402628Z 1 [Note] A temporary password is generated for root@localhost: W6+uRkglZ0ex

9.修改密码

mysql -u root -p
    输入上一步获取的临时密码
    #5.7出于安全考虑不让设置简单密码，要先更改其密码机制
    set global validate_password_policy=LOW;
    # 设置密码长度
    set global validate_password_length=6;
    # 修改密码
    SET PASSWORD = PASSWORD('123456');
    ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
    flush privileges;
    use mysql;
    update user set host = '%' where user = 'root';
    # 使配置生效
    flush privileges;

10.设置字符集

set character_set_database=utf8;
    flush privileges;