centos7安装mysql

安装mysql5.7

1、 下载mysql安装包

wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

2、执行mysql安装包

rpm -ivh mysql57-community-release-el7-11.noarch.rpm

3、安装MySQL

yum install mysql-community-server -y

4、验证mysql

启动mysql
systemctl start mysqld
查看mysql状态
systemctl status mysqld

5、登陆mysql

获取临时密码
grep 'temporary password' /var/log/mysqld.log

登录
mysql -u root -p

设置新密码
SET PASSWORD = PASSWORD('root账户密码');

6、修改密码规则（不同版本的mysql的变量名不一样）

set global validate_password_policy=0;
set global validate_password_length=3;

7、重设密码

alter user 'root'@'localhost' identified by '1234';

8、开机自启

systemctl enable mysqld.service

9、远程连接问题

# 允许任意ip以root账户访问mysql
grant all privileges on *.* to root@'%'  identified by 'root账户的密码；
# 刷新
flush privileges;

 重启服务器

 开通3306端口

常用命令

1. 启动mysql
systemctl start mysqld.service

2. 关闭mysql
systemctl stop mysqld.service

3. 重启mysql
systemctl restart mysql.service

4. 开机自启
systemctl enable mysqld.service

5. 查看mysql版本
select version();

6. 登录mysql
mysql -u username -p

7. 退出
quit;