MySQL Forums
Forum List  »  General

CRITICAL - cannot connect to information_schema. Access denied for user <user>@x.x.x.x (using password: YES)
Posted by: Saju Murali
Date: October 05, 2009 04:07AM

Hi all......
I am new here. I configured Nagios and installed check_mysql_health to monitor mysql and made appropriate changes in the nagios configuration files also. But when I type the command in /usr/local/nagios/libexec/
./check_mysql_health -H <ip_add> --user <username> --password <passwd> --mode <mode>
I am getting an error: CRITICAL - cannot connect to information_schema. Access denied for user <user>@X.X.X.X (using password: YES). I had given all privileges to the user (grant all privileges on *.* to <user>@<ip_add>;)

But I can connect to login to the mysql using the same username and password

(# mysql -u <user> -p
enter password: <passwd>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 160
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> )

Hope you can understand the things.
Kindly give me a solution for this..
Thanks for all in advance........

Saju Murali

Options: ReplyQuote


Subject
Written By
Posted
CRITICAL - cannot connect to information_schema. Access denied for user <user>@x.x.x.x (using password: YES)
October 05, 2009 04:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.