一、yum 下载
Mysql开源数据库
https://www.mysql.com //mysql官网
yum安装步骤
yum安装
1.下载yum源的rpm包
yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-11.noarch.rpm
vim /etc/yum.repos.d/mysql-community.repo
把安装5.7的源打开, 关闭安装8.0的源
2.yum安装mysql
#关闭防火墙和selinux
[root@mysql ~]# sed -ri s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config && setenforce 0
[root@mysql ~]# systemctl stop firewalld && systemctl disable firewalld
安装必要的软件包
[root@mysql ~]# yum -y groupinstall "Development Tools"
[root@mysql ~]# yum -y install mysql-community-server
[root@mysql ~]# systemctl start mysqld
3.数据库 启动
systemctl start mysqld
4.获取数据库密码 修改密码
获取密码: grep "password" /var/log/mysqld.log
登录数据库: mysql -uroot -p'密码'
在数据库里修改密码: alter user 'root'@'localhost' identified by "QianFeng@123";
在命令行修改密码: mysqladmin -uroot -p'old_passwd' password "new_passwd"