title: Upgrading MySQL on Mac OS X Server
body: <p>I'm attempting (and failing) to upgrade MySQL on Mac OS X Server (Leopard) and running into trouble. Though the OS X Server docs say it's "normal" to have multiple versions of MySQL on your machine they don't go into any detail of how to "manage" them. </p>
  
  <p>I have built and installed a newer version (5.1.40) than the original that Apple bundled (5.0.x). </p>
  
  <p>Server Admin seems to manage only the initial (5.0.x) installation in /usr/bin</p>
  
  <p>So I've STOPPED that version in Server Admin but can't get the new one (in /usr/local/mysql) to work.</p>
  
  <p>Ideally <strong>I'd like to point the new version of mysql at the old database files in /var/mysql</strong> but not sure how... </p>
  
  <p><strong>Edit:</strong> Looks like my new MySQL is active (for some users anyway) but it's pointing to a different data file. It's pointing to <code>/usr/local/mysql/data</code> and I want it to point to <code>/var/mysql</code></p>
  
  <p>Admin user can connect but others get: <code>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)</code>. I'm assuming because this new database doesn't have those users enabled yet?!?! though I'd think I could still <code>$ mysql -u root -p</code> to it?!?</p>
  
  <p>Anyone know how to manage this? </p>