centos7安装mysql

下载文件安装

wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
yum install mysql80-community-release-el7-3.noarch.rpm

需要的话版本修改成5.7

vim /etc/yum.repos.d/mysql-community.repo

把5.7和8.0的enabled都修改了

启动数据库

systemctl start mysqld

连接数据库

先查找临时的数据库密码
cat /var/log/mysqld.log |grep password
localhost：后面的就是
进入数据库
mysql -uroot -p
密码输入上面查找到的

修改数据库密码

alter user root@localhost identified with mysql_native_password by ‘新密码’;

退出之后在登陆输入：
GRANT ALL PRIVILEGES on . to ‘用户名’@‘localhost’ IDENTIFIED BY “新密码” WITH GRANT OPTION;

完成