Centos7安装Mysql5.7

来源：互联网发布：mac版360浏览器编辑：程序博客网时间：2024/06/15 12:28

1.卸载已安装的Mysql与Mariadb

    # rpm -qa | grep mysql | xargs rpm -e --nodeps    # rpm -qa | grep mariadb | xargs rpm -e --nodeps

2.将安装包mysql-5.7.14-1.el7.x86_64.rpm-bundle.tar上传到服务器/opt/mysql目录下
3.进入/opt/mysql目录，解压

    # tar -xvf mysql-5.7.14-1.el7.x86_64.rpm-bundle.tar    # rm -rf mysql-5.7.14-1.el7.x86_64.rpm-bundle.tar

4.按照依赖关系依次安装rpm包
依赖关系依次为common→libs→client→server

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

5.启动Mysqld服务并添加到开机自启动

    # systemctl start mysqld    # systemctl enable mysqld

6.查看Mysqld状态

    # systemctl status mysqld

7.找到临时登录密码

    # vi /var/log/mysqld.log

这里写图片描述
8.登录

    # mysql -u root -p

然后输入上一步的密码登录
9.修改root密码

    alter user 'root'@'localhost' identified by 'root';

在5.6后，mysql内置密码增强机制，低强度密码会报错：
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
配置root远程登录

    use mysql;    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

阅读全文

0 0