mysql 5.7 升级后nagios check_mysql不能用的问题

前端之家收集整理的这篇文章主要介绍了mysql 5.7 升级后nagios check_mysql不能用的问题前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

<table class="text"><tr class="li1">
<td class="ln"><pre class="de1">1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

MysqLclient.so.18 不再有 可以用   /usr/lib/x86_64-linux-gnu# ln -s libMysqLclient.so.20 libMysqLclient.so.18   建立软链接代替代旧的文件。     check_MysqL_slave也变得不能用,需修改权限   cat /usr/local/nagios/libexec/check_MysqL_slave   #!/bin/bash declare -a slave_is slave_is=($(MysqL -unagios -pmypass -e "show slave status\G"|grep Running |awk '{print $2}')) if [ "${slave_is[0]}" = "Yes" -a "${slave_is[1]}" = "Yes" ]      then      echo "OK -slave is running"      exit 0 else      echo "Critical -slave is error"      exit 2 fi       /usr/local/nagios/libexec/check_MysqL_slave MysqL: [Warning] Using a password on the command line interface can be insecure. ERROR 1227 (42000) at line 1: Access denied; you need (at least one of) the SUPER,REPLICATION CLIENT privilege(s) for this operation Critical -slave is error       grant REPLICATION client on *.*  to nagios@'localhost' identified by 'mypass';    

猜你在找的程序笔记相关文章