How to Install MySQL Client on MacOS BigSur using Homebrew and MAMP

Are you trying to install MySQL client on your MacOS BigSur 11.1? If so, you're not alone! With the default installation of Homebrew, you might find yourself stuck with MySQL 8.0 and OpenSSL 1.1, which can be a bit limiting if you need to work with older Rails versions.

In this article, we'll explore how to install an older version of MySQL client on your Mac using Homebrew and MAMP.

The Problem

As you might know, Homebrew no longer stores OpenSSL 1.0 anymore. This means that installing an older version of MySQL client requires some extra steps. Our goal is to set up a local environment on our Mac that allows us to work with Rails 3.2, which is the version we're stuck with for legacy applications.

The Solution

To achieve this, you'll need to install an older version of OpenSSL and then use MAMP to create a MySQL database. Here's what worked for me:

1. Clean up previous attempts: Before installing anything new, make sure to remove any faulty installations from previous attempts.

2. Install OpenSSL 1.0.2t: You can do this using the following command: `brew install openssl@1.0.2t`

3. Install MySQL: Use Homebrew to install an older version of MySQL, such as MySQL 5.x: `brew install mysql@5.x`

Installing MAMP and phpMyAdmin

To create a MySQL database, we'll use MAMP (Mac OS X, Apache, MySQL, PHP) and phpMyAdmin. Here's how:

1. Install MAMP: You can download MAMP from the official website.

2. Import your database: Use phpMyAdmin to import your existing database with all its tables.

Installing mysql2 Gem

Now that we have our local environment set up, let's install the mysql2 gem version 0.3.x, which allows smooth migration from Rails 3.2 to Rails 4.2 through versions 4.0 and 4.1:

1. Install the mysql2 gem: Use pip to install the mysql2 gem: `pip3 install mysqlclient`

In this article, we've explored how to install an older version of MySQL client on MacOS BigSur using Homebrew and MAMP. With these steps, you should now be able to set up a local environment that allows you to work with Rails 3.2 and legacy applications.

Remember to pay close attention to the path where you have installed mysql_config and OpenSSL 1.0, as this is crucial for successful installation. Happy coding!

Mysql client mac brew