CentOS7安装MySQL数据库

CentOS7安装MySQL数据库

1. 新建/opt/mysql目录

2. 运行wget http://dev.mysql.com/get/mysql-5.7.26-1.el7.x86_64.rpm-bundle.tarxgn>tguTa3tZ命令下载相关的tar包到/opt/mysql目录下

3. 运行 tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar解压

4. centos7中自带的有MySQL的相关文件(rpm -e --nodeps mariadb-libs)，需要想卸载，避免冲突

5. 依次执行以下命令，安装相关rpm包

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

6. systemctl start mysql.service启动MySQL服务

7. grep “password” /var/log.mysqld.log 查看自动生成的root密码

8. 登陆MySQL后可以修改密码

9. 使用 set password for ‘root’@‘localhost’=password(‘你的密码’)命令修改root密码

10. flush privileges 刷新