centos7 安装 mysql
命令记录，未整理；
1. 下载mysql5.7的安装包，上传到linux系统某个目录中
2. 使用tar -xvf 解压 tar包
tar -xvf mysql-5.7.35-1.el7.x86_64.rpm-bundle.tar
3. 使用 rpm -ivh 安装 mysql
rpm -ivh mysql-community-common-5.7.35-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.35-1.el7.x86_64.rpm
刷新权限，然后输入改密码的命令
flush privileges;
修改密码
alter user root@localhost identified by 'Zzq123456';
systemctl stop mysqld
systemctl status mysqld
systemctl start mysqld
#binlog日志过期天数设置
#expire_logs_days=7
server-id = 1
binlog-do-db=crmeb
#binlog-do-db=
binlog-ignore-db=mysql
binlog-ignore-db=information_schema
binlog-ignore-db=performance_schema
binlog-ignore-db=sys
#expire_logs_days=7
---------------------------
show databases;
use mysql;
show tables;
CREATE USER 'zzq'@'%' IDENTIFIED BY 'Zzq123456';
GRANT ALL ON *.* TO 'zzq'@'%';
FLUSH PRIVILEGES;
------------------------------------
show databases;
use mysql;
show tables;
SELECT User, Host FROM mysql.user;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'Zzq*123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit
-----------------------------------------
查看3306端口：
netstat -talnp
-----------------------------------------
查看防火墙状态：
systemctl status firewalld
firewall-cmd --state
-----------------------------------------
虚拟机：192.168.124.101
mysql 在虚拟机上本地登录的密码：root Zzq123456
mysql 在虚拟机上远程登录的密码：root Zzq*123456
ps -ef |grep mysql