title: How can I rework my MySQL password so that I can rake db: create on rails?
body: <p>I've very much so tried it all.</p>
  
  <p>when I db:rake create, I get the following:
  Access denied for user 'root'@'localhost' (using password: NO). 
  Please provide the root password for your mysql installation
  >
  rake aborted!</p>
  
  <p>There is no password set.  And I've searched all day on stackoverflow and on google.
  I've even set a password for it and tried that out.</p>
  
  <p>Yes, I've been to <a href="http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix" rel="nofollow">http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix</a></p>
  
  <p>But when I followed the instructions to reset the password, terminal and myself are unable to locate the .pid file!</p>
  
  <p>I've tried using the mysqld_safe with --skip-grant-tables option and wound up with this:</p>
  
  <p>110821 23:32:22 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
  rm: /tmp/mysql.sock: Permission denied
  110821 23:32:24 mysqld_safe mysqld from pid file /usr/local/var/mysql/Tony-Ngs-MacBook-Air.local.pid ended</p>