title: 64 characters length of mysql MD5?
body: <p>When I run:</p>
  
  <pre><code>SELECT MD5(  "WhatIsWrongWithThis?" ) AS hash
  </code></pre>
  
  <p>I get a 64 characters long output</p>
  
  <pre><code>6631303664616331363338613139623830363332663233656662643635633039
  </code></pre>
  
  <p>that differs from my PHP 32 expected output</p>
  
  <pre><code>f106dac1638a19b80632f23efbd65c09
  </code></pre>
  
  <ul>
  <li>I noticed that my remote mysql is fine.</li>
  <li>Already restarted the mysql service.</li>
  </ul>
  
  <p><img src="https://i.stack.imgur.com/V1Y8K.png" alt="local and remote mysql md5 comparison"></p>
  
  <p><strong>What is happening here?</strong></p>
  
  <hr>
  
  <p><strong>UPDATE:</strong></p>
  
  <p><strong>Note:</strong> the problem was happening in two levels: </p>
  
  <ol>
  <li>PHP/MySQL <code>SOLVED by reboot</code></li>
  <li>phpMyAdmin <code>SOLVED by checkbox</code></li>
  </ol>
  
  <p><strong>1. PHP/MySQL</strong></p>
  
  <p>I had already tried stopping and restarting the mysql server and nothing.. <em>Then after I rebooted the computer <strong>problem 1. disappeared</em></strong>. </p>
  
  <p><strong>STILL HAVE NO IDEA WHY</strong></p>
  
  <p><strong>2. phpMyAdmin</strong></p>
  
  <p>After the answers and comments I saw that indeed the phpMyAdmin had the "Show binary contents as HEX" checkbox checked... <strong>Unchecking it solved the problem 2 phpMyAdmin issue</strong>:</p>
  
  <p><img src="https://i.stack.imgur.com/DAlzY.png" alt="enter image description here"></p>