How to install MySQL 5.6 on OSX Mojave?

mysql macos-mojave mysql-5.6
Vadorequest picture Vadorequest · Feb 28, 2019 · Viewed 9.5k times · Source

I need to install MySQL 5.6 on my Mac, running under Mojave. (Because AWS Aurora Serverless only allows MySQL 5.6)

That wouldn't be an issue if a .dmg was available, but there are none for MacOS for this particular version, too old I guess?

See https://dev.mysql.com/downloads/mysql/5.6.html

enter image description here

No Mac OS in the list. I tried to play around with the URL to see if there was a non-reference dmg file, but no luck.

Which leads me to two choices:

  • Install it from source (is it possible? how?)
  • Install it in a Docker container

I don't know what's the most simple/straightforward way to install it. It's only meant to be used locally.

Answer

Carlos Henrique Moreira Dos S. picture Carlos Henrique Moreira Dos S. · Jul 1, 2019

To install:

brew install [email protected]

To have launchd start [email protected] now and restart at login:

brew services start [email protected]

Or, if you don't want/need a background service you can just run:

/usr/local/opt/[email protected]/bin/mysql.server start

Related questions

How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
MySQL error code: 1175 during UPDATE in MySQL Workbench

I'm trying to update the column visited to give it the value 1. I use MySQL workbench, and I'm writing the statement in the SQL editor from inside the workbench. I'm writing the following command: UPDATE tablename SET columnname=1; It gives …

Read More