Create a gist now

Instantly share code, notes, and snippets.

Embed
What would you like to do?
OSX How To: Uninstall native MySQL and install MariaDB via Homebrew

OSX How To: Uninstall native MySQL and install MariaDB via Homebrew

This is a short overview on how to completely remove any old mysql server installs in OSX and upgrade to MariaDB without conflicts. Things can get a bit weird when you have various old installs of MySQL server floating around, and utilizing homebrew to install and upgrade MariaDB as a drop in replacement for MySQL has worked well, especially if you're used to managing MySQL installs via yum in linux.

First: Backup Your Data!

Backup all of your current databases with mysqldump

This isn't a tutorial on backups, and there are many ways to do it. You should know how to backup your data anyway. For this example, we'll do a full backup of our InnoDB databases.

$ mysqldump -uroot -p --all-databases --flush-logs --master-data=2 > all_databases.sql

Second: Backup Your MySQL User Permissions

Within the msyqldump above, make sure you have dumped the mysql.users table. Either do this, or dump your mysql table data independently, or make note of your existing mysql user permissions if you just want to manually add them to your clean new MariaDB server later. If you have a lot of different permissions setup, you will probably want to migrate them. If you don't have many db users, you may want to add them manually later so you can get a refresher of how your user permissions are setup. Either way, you should understand your user permissions before removing your old database.

Dump your existing mysql table:

$ mysqldump -uroot -p mysql > mysql.sql

After installing your new MariaDB server, you can restore the mysql database by executing:

$ mysql -uroot -p mysql < mysql.sql

then make sure to flush privileges for the new user permissions to take effect:

FLUSH PRIVILEGES

Remove MySQL

You are now ready to remove everywhere MySQL has put itself into your OSX system. You may opt to move these folders to a backup folder instead of removing them, but for our case, we want to remove MySQL completely so there are no conflicts later.

First, check where mysql is running on your system:

$ which mysql

You should see something like: /usr/local/mysql

Now, stop the database server:

$ sudo /usr/local/mysql/support-files/mysql.server stop

And move/backup or remove the following folders/files:

  • sudo rm /usr/local/mysql
  • sudo rm -rf /usr/local/mysql*
  • sudo rm -rf /Library/StartupItems/MySQLCOM
  • sudo rm -rf /Library/PreferencePanes/My*
  • rm -rf ~/Library/PreferencePanes/My*
  • edit /etc/hostconfig and remove the line MYSQLCOM=-YES-

These may not exist, but if they do, remove them to avoid any conflicts with other versions of MySQL:

  • sudo rm -rf /Library/Receipts/mysql*
  • sudo rm -rf /Library/Receipts/MySQL*
  • sudo rm -rf /private/var/db/receipts/*mysql*

Install MariaDB with Homebrew

First, make sure you have homebrew installed and running, and make sure everything is up to date:

$ brew update

You can then run searches (brew search mariadb) , and if you would like to get more information about it, you could do: brew info mariadb. When you're ready to install MariaDB, simply execute:

$ brew install mariadb

After homebrew installs MariaDB server, follow the onscreen instructions on how to install the database (mysql_install_db) and add your startup scripts if you want MariaDB to load on boot. You should also run mysql_secure_installation to lock down your install and set your root password.

You should now be able to login to mysql with your new root user and see the MariaDB message from the server:

$ mysql -uroot -p


Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 48
Server version: 10.0.14-MariaDB Homebrew

You can now import your mysql users and dumped databases file as needed.

@Varun006

This comment has been minimized.

Show comment
Hide comment
@Varun006

Varun006 Jul 29, 2017

Hi,

I am getting the below error when i install mariadb using brew.

WARNING: The host 'Varuns-MacBook-Pro.local' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
chown: /usr/local/var/mysql: Operation not permitted
Cannot change ownership of the database directories to the 'varundavda'
user.  Check that you have the necessary permissions and try again.

READ THIS: https://docs.brew.sh/Troubleshooting.html

These open issues may also help:
kitchen-sync bottle with mariadb - Library not loaded https://github.com/Homebrew/homebrew-core/issues/13680

Also, when i run

mysql -root

I get the following error.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I just have no idea, regarding what is wrong.

Varun006 commented Jul 29, 2017

Hi,

I am getting the below error when i install mariadb using brew.

WARNING: The host 'Varuns-MacBook-Pro.local' could not be looked up with resolveip.
This probably means that your libc libraries are not 100 % compatible
with this binary MariaDB version. The MariaDB daemon, mysqld, should work
normally with the exception that host name resolving will not work.
This means that you should use IP addresses instead of hostnames
when specifying MariaDB privileges !
chown: /usr/local/var/mysql: Operation not permitted
Cannot change ownership of the database directories to the 'varundavda'
user.  Check that you have the necessary permissions and try again.

READ THIS: https://docs.brew.sh/Troubleshooting.html

These open issues may also help:
kitchen-sync bottle with mariadb - Library not loaded https://github.com/Homebrew/homebrew-core/issues/13680

Also, when i run

mysql -root

I get the following error.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I just have no idea, regarding what is wrong.

@maindufeu

This comment has been minimized.

Show comment
Hide comment
@maindufeu

maindufeu Aug 1, 2017

Hi, I want to install MariaDB without homebrew But I had already install MariaDB with brew, someone knows how to uninstall?

I followed the steps above to install it and it worked, then I tried to install MariaDB from the web and it brokes down. Now I can't use it either

maindufeu commented Aug 1, 2017

Hi, I want to install MariaDB without homebrew But I had already install MariaDB with brew, someone knows how to uninstall?

I followed the steps above to install it and it worked, then I tried to install MariaDB from the web and it brokes down. Now I can't use it either

@mscheffer

This comment has been minimized.

Show comment
Hide comment
@mscheffer

mscheffer Nov 26, 2017

also getting ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

also getting ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

@nouhabel

This comment has been minimized.

Show comment
Hide comment
@nouhabel

nouhabel Feb 13, 2018

is Mysql service started in your device?

is Mysql service started in your device?

@10001oleg

This comment has been minimized.

Show comment
Hide comment
@10001oleg

10001oleg Mar 18, 2018

me to => Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

**ck this manual!

me to => Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

**ck this manual!

@Juliamd

This comment has been minimized.

Show comment
Hide comment
@Juliamd

Juliamd Apr 1, 2018

Hi,

I have trouble uninstalling mariadb 10.2.14 on my macOS High Sierra Version 10.13.4 and I don't know coding. Please help. Thank you.

Juliamd commented Apr 1, 2018

Hi,

I have trouble uninstalling mariadb 10.2.14 on my macOS High Sierra Version 10.13.4 and I don't know coding. Please help. Thank you.

@elhardoum

This comment has been minimized.

Show comment
Hide comment
@elhardoum

elhardoum Apr 4, 2018

@10001oleg it's probably because the mysql daemon didn't start yet. To do so run brew services start mariadb (or brew services start mysql for those who installed mysql client instead of mariadb client)

@10001oleg it's probably because the mysql daemon didn't start yet. To do so run brew services start mariadb (or brew services start mysql for those who installed mysql client instead of mariadb client)

@elhardoum

This comment has been minimized.

Show comment
Hide comment
@elhardoum

elhardoum Apr 4, 2018

@Juliamd try this:

brew services stop mariadb
brew uninstall mariadb --force

elhardoum commented Apr 4, 2018

@Juliamd try this:

brew services stop mariadb
brew uninstall mariadb --force
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment