Tuesday, January 4, 2011

Completely Remove MySQL on Mac OS X

I was getting my Mac ready to do some Rails development with a MySQL database and I ran into a problem installing MySQL 5.5.8 on OS X 10.6.5.  I downloaded the .DMG and ran through the mysql-5.1.54-osx10.6-x86_64.pkg installer without a problem.  However, after installing the server and the MySQL.prefPane I could not start the server from the preference pane.  Then I noticed that the installer did not run scripts/mysql_install_db as part of the post installation process.  Well my first thought is that I obviously did something wrong so I thought I'd remove MySQL and start over again.  So, I did some googling and found these steps to completely remove MySQL:


  1. sudo rm /usr/local/mysql
  2. sudo rm -rf /usr/local/mysql*
  3. sudo rm -rf /Library/StartupItems/MySQLCOM
  4. sudo rm -rf /Library/PreferencePanes/My*
  5. (Edit /etc/hostconfig) sudo vi /etc/hostconfig (Remove line MYSQLCOM=-YES)
  6. sudo rm -rf /Library/Receipts/mysql*
  7. sudo rm -rf /Library/Receipts/MySQL*
  8. sudo rm -rf /var/db/receipts/com.mysql.*

Apparently the receipts are in a different location for the newer versions of MySQL so line #8 was added to clean them out as well.  Remember, these steps will completely remove MySQL and any data residing in the default locations.

So, back to my struggles.  I ended up installing MySQL 5.5.8 a couple of times using different archives with the same result so this removal process came in real handy...I almost made a script out of it.  After getting pretty frustrated with version 5.5.8 I ended up installing version 5.1.54 without a problem and it is running fine!?!?!

Cheers!

18 comments:

nbarthelemy said...

Thank you so much #8 was what every other post was missing.

Pete said...

I got the PreferencePane working by editing/usr/local/mysql/support-files/mysql.server with these values:

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

So now I could easily start & stop the server, but I could never get the mysql gem to work correctly. It would seem to install correctly, but running 'rake db:migrate' as a test would always return

uninitialized constant MysqlCompat::MysqlRes

I finally gave up & tried installing MySQL 5.1.54 but then ran into the problem that your step #8 fixed. Now MySQL runs fine and the gem installed correctly. So much wasted time....

Rod Biresch said...

Pete,
I'm glad to hear that this post help you! I had problems installing the mysql gem. I finally got the gem installed using...

sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config

Cheers!
Rod

Jérôme said...

Thanks Rod for the the step 8, hopefully Google found you! I could uninstall MySQL 5.1 with it.

Thanks Pete for the two lines, they fix well the preference panel and terminal command :)

Note: I didn't install the Automatic startup thing

Anonymous said...

this finally works - thanks, you're a great hero!

Mike said...

#8 was what was missing in all the other guides.

stammtisch said...

THNAK YOU for #8 !!!

Anonymous said...

Thanks a lot man!! really helpful and works like a charm

ankit goel said...

thanx a lot.. i installed mysql 5.5.28 8 times and couldnt get it to work..finally 5.1 is working great ..

Anonymous said...

Not so far I have found new cool tool to work with mySQL on mac os x - Valentina Studio. Its free edition can do things more than many commercial tools!!
I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview
You can install Valentina Studio (FREE) directly from Mac App Store: https://itunes.apple.com/us/app/valentina-studio/id604825918?ls=1&mt=12


newmac said...

sorry new to mac... Do i add the lines in terminal?

Rod Biresch said...

Yes, execute each command in the terminal

mahasiswa teladan said...

hi...Im student from Informatics engineering nice article,
thanks for sharing :)

Anonymous said...

I recommend using srm which overrites the data completely

alredi said...

I'm having problems with step #5. Once I delete the line, I have no idea how to progress. I tried CTRL-X, OPTION-X, CMD-X... (CTRL-X was recommended by another site). Any suggestions?

Rod Biresch said...

alredi, the command in step #5 puts you in the vi editor. To save your changes, press ESC then enter ':wq' without the single quotes. That will tell vi to 'w' write the changes and 'q' quit the editor. I suggest searching for 'vi commands' in your favorite web search tool.

Teemu Pasila said...

We have a problem installing mysql after this.

The install script I'm trying to run is: bash <(curl -Ls http://git.io/eUx7rg)

That I got from page:
http://www.macminivault.com/mysql-mavericks/

It stops saying that the pid file in /var/local/mysql/data was not updated.

The computer is with Mac Os X Mavericks.

Anonymous said...

Teemu pasila did you try removing sequel pro too? I was having the same problem I restarted the computer after removing mysql and it worked fine.