Description of problem:
The MySQL resource agent logs a lot of error messages to the system log. These messages are generated by the monitor action. 
--- snip ---
Oct  6 17:35:57 HOST lrmd: [1513]: info: RA output: (rsc_core_mysql:0:monitor:stderr) ERROR
Oct  6 17:35:57 HOST lrmd: [1513]: info: RA output: (rsc_core_mysql:0:monitor:stderr)  1045 (28000)
Oct  6 17:35:57 HOST lrmd: [1513]: info: RA output: (rsc_core_mysql:0:monitor:stderr) : Access denied for user 'root'@'localhost' (using password: NO)
--- snip ---

There is a configuration which controlls if the script will log in to mysql or just execute a PID check (kill -0). This option does not fully work in the shipped implementation. A bugfix was released upstream:
https://github.com/ClusterLabs/resource-agents/commit/259cb54f1a47a527085e3138955b4cc26b62d37c

Version-Release number of selected component (if applicable):
resource-agents-3.0.12-15.el6.x86_64

How reproducible:
create a simple cluster (a single node is enough)

create a mysql resource
primitive rsc_mysql ocf:heartbeat:mysql \
  params binary="..." client_binary="..." config="/etc/my.cnf" pid="..." socket="..." datadir="..." user="mysql" group="mysql" \
  op monitor interval="30s" timeout="70s" depth="0" \
  op start interval="0" timeout="120s" \
  op stop interval="0" timeout="120s"

Set a password for the mysql root user.

Actual results:
in syslog:
Oct  6 17:44:30 HOST mysql[25802]: INFO: MySQL monitor succeeded
Oct  6 17:44:58 HOST lrmd: [1513]: info: RA output: (rsc_x3_mysql:0:monitor:stderr) ERROR
Oct  6 17:44:58 HOST lrmd: [1513]: info: RA output: (rsc_x3_mysql:0:monitor:stderr)  1045 (28000)
Oct  6 17:44:58 HOST lrmd: [1513]: info: RA output: (rsc_x3_mysql:0:monitor:stderr) : Access denied for user 'root'@'localhost' (using password: NO)

Expected results:
in syslog:
Oct  6 17:44:30 HOST mysql[25802]: INFO: MySQL monitor succeeded

Additional info:
The resource agent for MySQL (/usr/lib/ocf/resource.d/heartbeat/mysql) can monitor a MySQL Server with a simple PID check and a more complex SQL Query. For the SQL query to work you have to specify a username and a password which the script uses to access mysql. You can chose, if you want to execute the SQL check by setting $OCF_CHECK_LEVEL to a Value > 0. This should disable all SQL based checks.