title: Why can't I drop MySQL Database?
body: <h1>Problem</h1>
  
  <p>I'm running <strong>MySQL 5.5.23</strong> on <strong>Mac OS 10.8.2</strong> and am unable to drop a particular database, but I can drop others.</p>
  
  <p>When I attempt to drop the specific table I get this error:</p>
  
  <pre><code>#1548 - Cannot load from mysql.proc. The table is probably corrupted
  </code></pre>
  
  <h2>Attempted Fixes</h2>
  
  <ul>
  <li>I have restarted the system</li>
  <li>I have tried to restart MySQL via CLI
  
  <ul>
  <li><code>$ sudo /usr/local/mysql/support-files/mysql.server stop</code></li>
  <li>but received this error <code>ERROR! MySQL server PID file could not be found!</code></li>
  </ul></li>
  <li>I have repaired the mysql.proc table. 
  
  <ul>
  <li><code>REPAIR TABLE mysql.proc</code></li>
  <li><code>REPAIR TABLE mysql.proc USE_FRM</code></li>
  </ul></li>
  <li>I have repaired all mysql.* tables. 
  
  <ul>
  <li><code>REPAIR TABLE mysql.*</code></li>
  </ul></li>
  <li>When running <strong>mysqlcheck</strong> from the Command Line
  
  <ul>
  <li><code>mysqlcheck --repair --all-databases</code></li>
  <li><code>mysqlcheck --repair specific-db</code>
  
  <ul>
  <li>I received this error : <code>mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) when trying to connect</code></li>
  </ul></li>
  </ul></li>
  </ul>
  
  <h2>Current Status</h2>
  
  <p>I still cannot drop the original specific database, but can drop others.</p>
  
  <h2>Update[1] 2013-01-05 11:15 am [New York]</h2>
  
  <p><strong>Logs and Feedback (per @Thomas in comments)</strong>
  To find all logs, I ran (cli): </p>
  
  <pre><code>$(ps auxww|sed -n '/sed -n/d;/mysqld /{s/.* \([^ ]*mysqld\) .*/\1/;p;}') --verbose --help|grep '^log'
  </code></pre>
  
  <p><em>I received this feedback:</em></p>
  
  <pre><code>130105 11:35:21 [Warning] Can't create test file /usr/local/mysql-5.5.23-osx10.6-x86_64/data/wills-mbp.lower-test
  130105 11:35:21 [Warning] Can't create test file /usr/local/mysql-5.5.23-osx10.6-x86_64/data/wills-mbp.lower-test
  130105 11:35:21 [Note] Plugin 'FEDERATED' is disabled. /usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
  130105 11:35:21 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
  </code></pre>
  
  <p>I'm looking into the <code>mysql_upgrade</code>.</p>
  
  <h2>Update[2] 2013-01-05 4:04 pm [New York]</h2>
  
  <p>I ran this :</p>
  
  <pre><code>sudo /usr/local/mysql/support-files/mysql.server stop
  </code></pre>
  
  <p>And received this error:</p>
  
  <pre><code>ERROR! MySQL server PID file could not be found!
  </code></pre>
  
  <p><strong>Update[2.1] 2013-01-05 5:37 pm [New York]</strong></p>
  
  <p>I ran <code>ps auxww | grep mysql</code> and found the <code>mysqld</code> process and killed it (<code>sudo kill [process id]</code>). I was then able to restart mysql successfully. However, I'm still having no luck dropping that specific database mentioned above.</p>
  
  <h2>Resolved</h2>
  
  <p>After trying to manually repair the corruption and many of the suggestions and the other answer listed here, reinstalling mySQL was the only thing that solved my problem.</p>
  
  <p>On a <em>Mac</em> (running 10.8.2) I also had to do some manual deletions for a clean install:</p>
  
  <pre><code>sudo rm /usr/local/mysql
  sudo rm -rf /usr/local/mysql*
  sudo rm -rf /Library/StartupItems/MySQLCOM
  sudo rm -rf /Library/PreferencePanes/My*
  sudo rm -rf /Library/Receipts/mysql*
  sudo rm -rf /Library/Receipts/MySQL*
  sudo rm /etc/my.cnf
  </code></pre>
  
  <hr>
  
  <h2>Articles consulted</h2>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/9566085/mysql-duplicates-with-concat-error-1548-cannot-load-from-mysql-proc-the-table">MySQL duplicates with CONCAT error 1548 - Cannot load from mysql.proc. The table is probably corrupted</a></li>
  <li><a href="https://stackoverflow.com/questions/11837182/sql-error-bigint-unsigned-value-is-out-of-range-in-but-it-doesnt-make-s">SQL error: BIGINT UNSIGNED value is out of range in (…), but it doesn't make sense</a></li>
  <li><a href="https://stackoverflow.com/questions/6177246/how-to-repair-corrupted-table">How to repair corrupted table</a></li>
  <li><a href="https://stackoverflow.com/questions/10035497/mysql-manager-or-server-pid-file-could-not-be-found">MySQL manager or server PID file could not be found</a> </li>
  <li><a href="https://discussions.apple.com/message/12176949?messageID=12176949#12176949?messageID=12176949" rel="noreferrer">PHP/MySQL issue after security update 2010-005</a></li>
  <li><a href="https://serverfault.com/questions/178088/mysql-problems-after-mac-os-x-software-update">mysql problems after Mac OS X software update</a></li>
  <li><a href="http://tomkeur.net/39/how-to-remove-mysql-completely-mac-os-x-leopard.html" rel="noreferrer">How to remove MySQL completely Mac OS X Leopard</a></li>
  </ul>