title: ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 0
body: <p>I am getting the following error </p>
  
  <pre><code>ERROR 2013 (HY000): Lost connection to MySQL server at 
  'reading authorization packet', system error: 0
  </code></pre>
  
  <p>when trying to connect to my MySQL server.</p>
  
  <p>What I am doing:</p>
  
  <ul>
  <li>I have Master - Slave replication in MySQL that is working and just added load balance capabilities using F5. </li>
  <li>I have configured the F5 according to their site. </li>
  </ul>
  
  <p>But when I am trying to connect to my MySQL server using the IP that the F5 was configured with I get </p>
  
  <pre><code>ERROR 2013 (HY000): Lost connection to MySQL server at 
  'reading authorization packet', system error: 0 
  </code></pre>
  
  <p>Any ideas?</p>
  
  <hr>
  
  <p>Update on my progress : <strong>ZERO</strong><br>
  - i am getting the same error 
  I get no entries in the /var/log/secure as if somebody would try to authenticate coming form the ip where i had created my load balance server.<br>
  No enties in the mysql error log.<br>
  The command - returns nothing</p>
  
  <pre><code>mysql&gt; SHOW GLOBAL STATUS LIKE 'Aborted_connections';
  Empty set (0.00 sec)
  </code></pre>
  
  <p>I've already altered my <code>my.cnf</code> file and add the </p>
  
  <pre><code>[mysqld]
  skip-name-resolve
  </code></pre>
  
  <p>Alterd the <code>connect_timeout</code> to 10.<br>
   So it seems i get no response for the server i have created on my F5 <br>
  I finally convinced the F5 admin to pass me the log for the F5 server and i have exctraced all i need form it.<br>
  <strong>Here is the output :</strong></p>
  
  <pre><code>  Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy &lt;CLIENT_ACCEPTED&gt;: BIG-IP MySQL Proxy -- clientside initial connection
  Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy &lt;CLIENT_ACCEPTED&gt;: BIG-IP MySQL Proxy -- clientside responding with server WELCOME packet
  Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy &lt;CLIENT_DATA&gt;: BIG-IP MySQL Proxy -- clientside authenticated flag not set
  Jan 28 15:46:39 tmm err tmm[6459]: Rule /Common/iRule-f5_mysql_proxy &lt;CLIENT_DATA&gt;: BIG-IP MySQL Proxy -- mysql client: attempting to do something before authentication
  Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy &lt;LB_SELECTED&gt;: BIG-IP MySQL Proxy -- serverside selected pool /Common/foss-mysql-slave_pool node SLAVE-IP
  Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy &lt;CLIENT_CLOSED&gt;: BIG-IP MySQL Proxy -- clientside connection closed from MASTER-IP(XXXXXXX)
  Jan 28 15:46:39 tmm debug tmm[6459]: Rule /Common/iRule-f5_mysql_proxy &lt;SERVER_CLOSED&gt;: BIG-IP MySQL Proxy -- serverside connection closed from node SLAVE-IP(XXXXXXXX)
  </code></pre>
  
  <p>I've replaced the ip for security sake ! <br></p>
  
  <p><strong>just as an extra</strong> - and i think is here the problem - my mysql version is <strong>5.1.69-log</strong>
  Thx All </p>