centos7安装mysql

指导命令，要知道安装那个包，所用的命令
yum provides iostat

　

[root@db01 ~]# rpm -ivh http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/mysql57-community-release-el7-10.noarch.rpm 
[root@db01 ~]# yum install mysql-community-server -y 
[root@db01 ~]# systemctl enable mysqld

 

[root@db01 ~]# systemctl restart  mysqld

　　

　　

[root@db01 ~]# mysql -uroot -p$(awk '/temporary password/{print $NF}' /var/log/mysqld.log)

　　

mysql>  set global validate_password_policy=LOW;
mysql> set global validate_password_length=6;
mysql>  SET PASSWORD = PASSWORD('123456');
mysql>  grant all privileges on *.* to 'root'@'%' identified by '123456';

[root@db01 ~]# systemctl restart  mysqld

　　

1.vim /etc/my.cnf 进行编辑，加入skip-grant-tables

2、systemctl restart mysqld 重启Mysql

4、输入命令重置密码

update mysql.user set authentication_string=PASSWORD('123456') where User='root';

更改密码为123456

再使用flush privileges;