Mysql安装rpm文件

最近安装tar文件（https://blog.csdn.net/zhaofengdeng/article/details/80367535），安装失败

所以选择安装rpm文件

下载地址

https://dev.mysql.com/downloads/mysql/

下载 comon ,libs,client,server

运行命令，有安装顺序

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

相关命令

# 启动mysql
service mysqld start

# 停止mysql
service mysqld stop

# 重启mysql
service mysqld restart

查看临时密码

grep password /var/log/mysqld.log

修改密码：

设置密码策略为低，要不可能修改的密码简单修改失败

set global validate_password_policy=LOW; 
alter user 'root'@'localhost' identified by '密码';

设置允许远程连接数据库，命令如下：

use mysql;
update user set user.Host='%' where user.User='root'; 

刷新权限，命令如下：

flush privileges;