title: HAProxy with mysql-check option, not working
body: <p>I have added an entry to my HAProxy connection to connect to a MySQL database. It is only for reading at present, not writing.</p>
  
  <p>I have set it up as follows:</p>
  
  <pre><code>frontend db_read_port33517
  mode    tcp
  option  tcplog
  bind *:33517
  default_backend db_slave_con
  
  backend db_slave_con
  option  mysql-check user haproxy post-41
  
     server database1   1.2.3.4:3307 check port 3307
     server database2   1.2.3.5:3307 check port 3307 backup
  </code></pre>
  
  <p>It is MySQL 5.7, and I have added a basic user to MySQL:</p>
  
  <pre><code>CREATE USER 'haproxy'@'1.0.0.0/255.0.0.0' IDENTIFIED BY 'some_password';
  </code></pre>
  
  <p>But looking at the the stats page, it can't connect to either database. This is the first time I have used the <code>mysql-check</code> option, but I'm guessing I have missed something, but having been through all the notes I can't see what it is?</p>
  
  <p>n.b. the databases both exist, and I can connect to them with the <code>haproxy</code> user..</p>
  
  <hr>
  
  <p>Looking in the logs, I can see I am getting <code>0Access denied for user 'haproxy'@'1.2.3.6'</code>. I have modified the user to be <code>haproxy@%</code> but that makes no difference. </p>
  
  <p>I am guessing that it is because the user was created with a password, (our policy dictates all database users must have a password) and HAProxy isn't passing across the password. Is there a way to specify the password in the HAProxy config?</p>