title: Mysql - Unable to enable remote access
body: <p>I'm having trouble logging in remotely to mysql.</p>
  
  <p>I've set up a user (open_user) without a password and I want to be able to connect with it to my db (open_db) from any remote server (yes I know its a security nightmare but I'm testing something out).
  I can log in successfully from the local server:
  <strong><em>mysql -openuser open_db</em></strong></p>
  
  <p>And when I view the grants for this user:
  <strong><em>show grants for openuser</em></strong>
  - I get this:</p>
  
  <p><strong>GRANT USAGE ON *.*  TO 'openuser'@'%'</strong> </p>
  
  <p><strong>GRANT ALL PRIVILEGES ON `open_db`.* TO 'openuser'@'%'</strong> </p>
  
  <p>My understanding is that this user should be able to log in from any server.</p>
  
  <p>However when I try this:
  <strong><em>mysql -uopenuser -hmyserver open_db</em></strong></p>
  
  <p>I get this:</p>
  
  <p><strong>ERROR 1045 (28000): Access denied for user 'openuser'@'xxx.xxx.xxx.xxx' (using password: NO)</strong></p>
  
  <p>I've also tried setting bind-address in /etc/mysql/my.cnf:</p>
  
  <p>bind-address            = 0.0.0.0</p>
  
  <p>Any ideas?</p>