Revisit MySQLdb installation for Mac OS X Lion

Recently while reinstalling MySQL and getting MAMP for mac, I got into the MySQLdb issue for python. Mainly is the wrong architecture issue. After updating to Mac OS X Lion, the OS is more stable for 64 bit than the previous OS.

However, even you have MAMP, better to install MySQL for Mac again just purely for the complete library. And remember to get all in 64 bit, MySQL and Python.

Edit the site.cfg of the MySQL

mysql_config = /usr/local/mysql/bin/mysql_config

Then just sudo python build and sudo python install.


Fully Uninstall MySQL on Mac

Here the command to type on terminal

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* 

Disable All Wordpress Plugin from Database

Sometimes your wordpress just not working, possible because one of the plugins just consume too much memory and causing the hiccup.

Here is a fast way to disable your plugins from the database. I suggest to back up the value inside before running the SQL command.

Just type the below SQL inside your database. If your wordpress prefix is “wp_”

SELECT * FROM wp_options WHERE option_name = 'active_plugins';