title: mysql command line connection to azure
body: <p>I am using azure and mysql. I CAN connect to the azure mysql instance with the GUI mysql workbench however trying to connect with the command line always gives an access denied.</p>
  
  <p>Here is my connection string (obfuscated) </p>
  
  <p>mysql -h azureserver -u myuser -p thepass -D thedatabase</p>
  
  <p>Here is the output from the command</p>
  
  <pre><code>$ mysql -h azureserver -u myuser -p thepass -D thedatabase 
  Enter password: 
  ERROR 1045 (28000): Access denied for user 'myuser'@'azureserver' (using password: NO)
  </code></pre>
  
  <p>Why can I connect with the GUI client and the command line client fails? I used the -p to specify a password but clearly the results implies that I am not using a password (see above) </p>
  
  <p>Am I missing some detail when trying to connect through the command line to an Azure mysql instance?</p>
  
  <p>The Azure tutorial implies that this is all I need <a href="http://www.windowsazure.com/en-us/develop/php/tutorials/website-w-mysql-and-git/" rel="nofollow">PHP mysql azure tutorial</a></p>
  
  <p>So to summarize:</p>
  
  <ol>
  <li>Yes the MySQL db is up and running. I can access it through my app AND I can access it through the GUI MySQLWorkbench</li>
  <li>Trying to access the db with the commandline tool fails indicating that I am not using a password when in fact I am with the -p switch.</li>
  <li>My dev box is running MacOSX</li>
  </ol>