Centos7.9安装Mysql5.7
Centos7.9安装Mysql5.7
ZhangCurry下载MySQL官方的yum源配置文件：
wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
安装yum源：
rpm -ivh mysql57-community-release-el7-10.noarch.rpm
安装MySQL服务：
curl -O https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
rpm –import RPM-GPG-KEY-mysql-2022
yum install -y mysql-community-server
启动并设置开机自启MySQL：
1 | systemctl start mysqld |
设置MySQL root密码：
查看初始密码，在MySQL日志中：
grep ‘temporary password’ /var/log/mysqld.log
登录MySQL，使用刚才查看到的初始密码：
1 | mysql -u root -p |
登录后修改root密码
ALTER USER ‘root‘@’localhost’ IDENTIFIED BY ‘ZabbixDBpassword123!’;
测试创建数据库zabbix
create database zabbix character set utf8 collate utf8_bin;
测试创建用户
CREATE USER ‘zabbix‘@’localhost’ IDENTIFIED BY ‘ZabbixDBPassword123!’;
赋予zabbix用户zabbs数据库所有权限
GRANT ALL PRIVILEGES ON zabbix.* TO ‘zabbix‘@’localhost’;
重新加载授权表
FLUSH PRIVILEGES;
退出
exit;
防火墙设置
允许3306端口
1 | firewall-cmd --zone=public --add-port=3306/tcp --permanent |
