一:查看是否安装有mysql
1.有安装则返回版本信息
rpm -qa | grep -i mysql
2.有安装则返回mysql的安装目录
whereis mysql
3.卸载删除装过的mysql:
(1)首先关闭mysql服务:service mysql stop;
(2)然后删除rpm -qa | grep -i mysql,用rm命令移除;
(3)然后再用find / -name mysql 命令删除依赖项。同样用rm命令移除;
(4)最后删除配置文件rm -rf /etc/my.cnf;最后rpm -qa|grep -i mysql检查一下是否删除干净;
二:卸载centos7本身自带的mariadb数据库:
1.rpm -qa|grep mariadb 查看mariadb的安装包,没有就不用卸了
2.rpm -e --nodeps mariadb-libs 删掉
三:下载mysql
1.wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
2.rpm -ivh mysql80-community-release-el7-3.noarch.rpm(源安装)
3.查看有哪些安装包
yum repolist all | grep mysql
4.yum -y install yum-utils
5.禁用默认的mysql8.0使用mysql5.7
yum-config-manager --disable mysql80-community
yum-config-manager --enable mysql57-community
6.yum install mysql-community-server -y
7.启动服务
systemctl start mysqld.service
8.查看服务运行状态
systemctl status mysqld.service
9.创建超级用户,并将临时密码保存到日志里,root@localhost:后面的就是临时密码
grep ‘temporary password’ /var/log/mysqld.log
10.登录mysql
mysql -u root -p
11.三条命令是降低密码复杂程度,至少8位字符的
set global validate_password_policy=0;
set global validate_password_length=1;
set global validate_password_mixed_case_count=2;
12.修改密码
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘新密码’;
13.退出:\q
四:使用zabbix监控mysql数据库
1.创建mysql监控用户
(1)GRANT USAGE ON . TO ‘zabbixmonitor’@‘localhost’ IDENTIFIED BY ‘passwd’;
(2)FLUSH PRIVILEGES;
2.zabbix agent配置
(1)检查include语句是否被注释,需要取消注释。
vim /etc/zabbix/zabbix_agentd.conf
第268行
(2)新建mysql配置文件,写入数据库连接方式
vim /etc/zabbix/.my.cnf
[client]
host = localhost
user = zabbixmonitor
password = passwd
(3)将/etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf中的/var/lib/zabbix替换为/etc/zabbix:
sed -i ‘s@/var/lib/zabbix@/etc/zabbix@g’ /etc/zabbix/zabbix_agentd.d/userparameter_mysql.conf
(4)重启zabbix agent
systemctl restart zabbix-agent
3.为mysql服务器主机链接监控模板“ Template DB MySQL ”,等待数据刷新