title: Restoring deleted 'root' user and password for MySQL
body: <p>I accidentally deleted the <code>root</code> user on my local dev setup of MAMP/MySQL running on OS X.  There are no other users created to get back into MySQL. </p>
  
  <p>This is a mild nightmare can't seem to do anything without <code>root</code>. </p>
  
  <p>Found this: <a href="http://hack2live.blogspot.com/2009/04/restore-repair-reset-mysql-root.html">http://hack2live.blogspot.com/2009/04/restore-repair-reset-mysql-root.html</a> which seems like exactly what I need. </p>
  
  <p>I also don't think a reinstall of MAMP will do the trick, as a lot of my cursory searches yielded people who had tried without success.</p>
  
  <p>Does anyone know of an OSX friendly way to recreate <code>root</code> @ <code>localhost</code> back into MAMP's MySQL? I basically just don't know where MySQL is living in MAMP or how to execute the correct commands in terminal to try and fix it.</p>
  
  <p><em>Update</em></p>
  
  <p>I tried several options below to restore root to no avail and decided to restore a backup of the entire MAMP application.  So I've got root back, I can open phpmyadmin, etc.  </p>