Setting up MySQL. I am on a Mac OS system using version Catalina. To have MySQL running on my machine I had to install the following tools; MySQL community server download link; MySQL workbench download link; If you are on a windows machine you can use the same tools or you can use XAMPP as well. Installing MySQL. Download and install the latest MySQL generally available release DMG for macOS. While MySQL 8 is the latest version, many of my projects still use MySQL 5.7. So I still prefer installing the older version.

• Can I Install Mysql On Mac

Question or issue on macOS:

I’m setting up my development environment in the new macOS Sierra .

First of all, I installed Rbenv, Ruby (2.3.1), Homebrew and so the latest version of MySQL (5.7.15).

Ok, MySQL was initialized. Time to install the mysql2 gem…

But it didn’t work. 😞

How to solve this problem?

Solution no. 1:

I just had the same problem, tried all of the solutions listed above, then commenced to bang my head against they keyboard for a couple of hours.

I then thought to try and install/reinstall the Xcode Command Line Tools:

Once I did that the mysql2 gem installed w/ no problems. I hope that does the trick!

Solution no. 2:

When you install openssl via brew, you should get the following message:

Apple has deprecated use of OpenSSL in favor of its own TLS and crypto libraries
Generally there are no consequences of this for you. If you build your
own software and it requires this formula, you’ll need to add to your
build variables:
LDFLAGS: -L/usr/local/opt/openssl/lib
CPPFLAGS: -I/usr/local/opt/openssl/include
PKG_CONFIG_PATH: /usr/local/opt/openssl/lib/pkgconfig

You can set these build flags (for the local application) by running the following:

This worked for me.

See bundler’s documentation for more information.

Solution no. 3:

Lots of great answers, I was able to combine them into this:

because I was not comfortable with bundle config

Solution no. 4:

I am here to share my fix, since the other answers didn’t work.

For my environment, I need MySQL 5.6 so I had to use:

brew install mysql56 instead of brew install mysql

Bundle installing the mysql2 gem kept failing, until:

brew link mysql56

I also ran afterwards:

mysql.server start

The last step might be unnecessary, but just in case.

Solution no. 5:

With Mac OS 10.15 Catalina when I tried Alessandro’s fix the gem and extensions could be installed correctly but bundle install failed. What worked was just:

without the cppflags part.

Solution no. 6:

Here’s what worked for me.

Originally I ran:

then

I received an error in /Users/…/.bundle/ruby/2.5.0/extensions/x86_64-darwin-18/2.5.0/mysql2-0.5.3/mkmf.log :

clang: error: unsupported option ‘–with-cppflags=-I/usr/local/opt/openssl/include’

So I removed “–with-cppflags=-I/usr/local/opt/openssl/include”

Then ran:

followed by:

Which worked.

Solution no. 7:

Almost the same scenario as @Caio Tarifa, Ruby 2.3.3, mysql 5.6 and mysql2. Tried on couple of solutions above and finally make it work with @kylekeesling’s approach.

First, tried on solution 1 by @spickermann:

Nothing happened, same error shown.

Second, tried on solution by @Alessandro Berardi:

This got different but more errors since it overwrite gem extension’s config so all gem extension installation failed.

Finally, tried on @kylekeesling solution:

It fix mysql gem issue as well as nikogiri. Since I already intall Xcode, in my case it’s reinstall the Xcode Command Line Tools.

Solution no. 8:

Try installing xcode-select –install

Solution no. 9:

So I ran into this similar issue and for me it turned out to be a wrong ruby version and incompatible MySQL version. I use ruby 2.3 on most of my projects but inherited a 2.1 project. Changing to rvm to use 2.1 got me a little further.

Then I found this: https://github.com/brianmario/mysql2/issues/603 that said you had to use mysql2 gem version greater than 0.3.17 with MySQL version 5.7

Updated gem to 0.3.17 and it fired right up. Hope this helps someone.

Solution no. 10:

If none of the above works .. like in my case, doing this solved the issue
brew install openssl

FYI: i am using MacOS Catalina

Hope this helps!

Can I Install Mysql On Mac