linux rpm安装mysql5.7.*密码策略,访问策略等常见问题

下载mysql

依次选择mysql版本.操作系统类型,操作系统版本,下载rpm全套版本

安装mysql

上传mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar文件到/var/tmp并解压

tar -xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

安装mysql

rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.28-1.el7.x86_64.rpm  
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm  
rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-devel-5.7.28-1.el7.x86_64.rpm

mysql配置文件

cat /etc/my.cnf

启动mysql

#查看进程
ps -ef|grep mysql
#查看状态
service mysqld status
#启动msyql
service mysqld start

修改初始密码

查看初始密码(最下面是最新的)

cat /var/log/mysqld.log |grep root@localhost

修改密码策略访问策略等

#连接mysql并输入密码
mysql -u root -p
#修改初始化密码
ALTER USER USER() IDENTIFIED BY 'TESTtest1234.';
#设置密码策略
set global validate_password_policy=0;
set global validate_password_length=1;
#使用mysql表
use mysql;
#修改密码
update mysql.user set authentication_string=password('root') where user='root';
#修改远程访问ip
update user set host = '%' where user ='root';
#刷新
flush privileges;
#退出
quit;