Mysql安装

第一步：添加MySQL Yum 仓库
从MySQL Yum 仓库http://dev.mysql.com/downloads/repo/yum/下载适合电脑版本的rpm包。
查看电脑版本
uname -a

下载命令
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

下载后执行

sudo rpm -Uvh mysql57-community-release-el7-11.noarch.rpm

第二步：安装MySQL

sudo yum install mysql-community-server

第三步：启动MySQL

sudo service mysqld start
sudo systemctl start mysqld.service

查看mysql服务状态
sudo service mysqld status

开机启动
sudo systemctl enable mysqld
sudo systemctl status mysqld.service

查看密码
sudo grep 'temporary password' /var/log/mysqld.log

修改root用户的密码

mysql -uroot -p

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';

第四步：连接远程数据库

查看一下user表
select user,host from user;

修改user表
update user set host = '%' where user = 'root';

刷新
flush privileges;

关于报错：
yum -y install mysql-community-server
Last metadata expiration check: 0:13:40 ago on Sun 26 Apr 2020 11:20:57 AM CST.
No match for argument: mysql-community-server
Error: Unable to find a match: mysql-community-server

解决：
先执行：yum module disable mysql
再执行：yum -y install mysql-community-server