I just went through a prolonged ordeal to upgrade MySQL from 5.1.30 to 5.1.47, so I'm going to write down some steps so that I don't hit so many dead-ends in the future. Note that this presumes that you have already done a DB dump of your wiki database (i.e. SequelPro's Export… command).

# * First, to run the <tt>mysql_upgrade </tt> script, enable the root user in Directory Utility (which is now in CoreServices, or accessible from the Account prefs Accounts prefpane).# * <tt>su -</tt># * <tt>su _mysql -c "/usr/local/mysql/mysql_upgrade"</tt># * <tt>logout</tt># * Restart MySQLNow, [http://dev.mysql.com/doc/refman/5.1/en/default-privileges.html secure the root/guest accounts], [http://dev.mysql.com/doc/refman/5.1/en/create-user.html create the wiki user] , and [http://www.mediawiki.org/wiki/Manual:Installing_MediaWiki#MySQL create the wiki db and grant privileges]. Go into LocalSettings.php and change the connection settings so that it doesn't try to connect to the DB until you are done with the rest. Then# * <tt>sudo mkdir /usr/local/mysql/etc</tt># * <tt>sudo mkdir chown -R mysql /usr/local/mysql/etc</tt># * <tt>su -</tt># * <tt>su -m _mysql -c "touch /usr/local/mysql/etc/my.cnf"</tt> (you can safely ignore the <tt>getcwd</tt> error)# * <tt>logout</tt># * Turn off root user# * Add this to the <tt>my.cnf</tt> file:

# * Restart MySQL again# * Fire up SequelPro and import the SQL dump made earlier. Errors related to disallowed <tt>DROP</tt> operations are fine.* Change back the connection parameters in LocalSettings.php and refresh the wiki!