centos安装mysql

1.查看本地是否有mysql-community安装源

yum search mysql-community

2.使用wget下载本地安装源

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

3.安装本地源

rpm -ivh mysql80-community-release-el7-3.noarch.rpm

4.安装mysql

yum install -y mysql-community-server  --nogpgcheck

如果出现
错误：没有任何匹配: mysql-community-server
则先禁用默认的mysql模块

yum module disable mysql

5.启动mysql

systemctl start mysqld

6.查看随机密码

cd /var/cache/yum/x86_64/7/mysql80-community/packages/
vi /var/log/mysqld.log

7.用密码登录mysql

 mysql -uroot -p

输入随机密码

8修改登录密码

alter user 'root'@'localhost' identified with mysql_native_password by 'XXXXXX';

9.修改root用户的权限

update user set host='%' where user='root';

%代表任意设备都可以使用root用户远程登录数据库
10使root用户的权限生效

flush privileges；

使得权限立即生效