title: allowing mysql connection without password
body: <p>For some reason, when creating a MySQL user with empty password, it only allows connections if the user has the same name as a system user (Ubuntu Server 10.04, MySQL version 5.1.41). According to everything I have read so far, MySQL users ought to be completely separate from the system user accounts, so I'm not sure how to explain what's going on.</p>
  
  <p>Am I doing something wrong? Is there some settings somewhere that affects this?</p>
  
  <p>(Additional info:
    I'm setting this up to only allow connections from the local network; some of the tools I'm using on a project require a user without a password.)</p>
  
  <p>This seems likely to be a duplicate, though when I searched I couldn't find any previous question about this issue. If the same question HAS been asked before, I apologize.</p>