A step-by-step guide 📙 on how to install, configure and run MySQL 8 server on macOS using Homebrew 🍺 I use Homebrew on macOS to manage all the packages I need for development. Once you understand how Homebrew works and how it helps you manage various packages on macOS, installing any dependency on your Mac becomes easy. We will install Homebrew and learn a few essential commands on how we can use Homebrew. Once through with installing Homebrew, we would then move on to and configure it. install MySQL server using Homebrew What is Homebrew? Homebrew is a package manager for macOS and Linux , but just putting it on record that it works with Linux as well 😊. (I know you would instead use apt-get or yum based on which Linux distro you are using) Why would you use a package manager like Homebrew when all the packages come with their independent files, and these files can be used to install each package independently? We use a package manager because of a couple of advantages package managers have to offer over independently installing each page. .pkg The main difference between Homebrew and the installer package is the fact that Homebrew takes care of the build time dependencies. If the package you are trying to install requires ruby and some of its dependencies, Homebrew does not require you to build/install ruby and libraries from scratch. Homebrew makes the process of installing packages easy. Every installed package is cleanly sandboxed into its cellar (directory), so you don't have stray files all over your system, just symlinks from bin, man, etc. In the case of macOS with Apple Silicon, all the packages are installed in directory. Hence you know where all packages are installed. /opt/homebrew/cellar Homebrew lets you install all the packages with root access and Homebrew installs without root access as well into or /usr/local (Intel) /opt/homebrew (Apple Silicon) Uninstalling is hardly an issue anymore. Homebrew will manage the uninstall process and trim the run time dependencies if needed. Homebrew provides you with many tools to manage all the packages installed on your machine, which includes various commands to list the packages installed, uninstall them, upgrade packages, search for packages, and so on. Step One: Installing the Xcode Command Line Tools Before we install any package or Homebrew itself, we first need to install the Xcode Command Line Tools. To do so on your Mac and run the following command. open the Terminal app xcode-select --install Step Two: Install Homebrew If you do not have Homebrew installed on your machine, you can follow along, but if you have Homebrew installed and already working with it, you can move on to the next step. You can check if Homebrew is installed on your machine by running the following command in your Terminal. brew --version If Homebrew is installed on your Mac, you should get a response containing the version of the Homebrew installed on your machine, which should look like this. Homebrew >=3.x.x

// Where 3.x.x is the version of the Homebrew installed on your machine. 
// Anything above 3 is good If Homebrew is already installed, you can move to the next step. If not, hang on while we install Homebrew. To install Homebrew, run the following command in your Terminal. /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)" The above command should install Homebrew for you and add it to the Path. If you are curious about Homebrew's steps while installing your machine, you can . read them here Once Homebrew is installed and rerun the following command to check if Homebrew was installed successfully on your machine. restart the Terminal app brew --version If Homebrew is installed on your Mac, you should get a response that will contain the homebrew version installed on your machine and should look like this. Homebrew >=3.x.x

// Where 3.x.x is the version of the Homebrew installed on your machine. 
// Anything above 3 is good Step Three: Install MySQL 8 Once Homebrew is installed, we will use it to install MySQL 8 on our machine. We would use the to install MySQL on our Mac. Still, run the following command in your Terminal to start the MySQL installation. MySQL formula brew install mysql Step Four: Configure MySQL The above command will install the latest version of MySQL on your Mac. Once MySQL is installed, we need to run the secure installation to assign a password to the root user and create and connect to databases using the root user. You might decide to create another user and not use the root user. But, for this tutorial and assuming that you are installing MySQL on macOS for development workloads, I will stick to using the root user. To secure your MySQL installation, run the following command. mysql_secure_installation Once you run this above command, you will be requested to assign a password to the root user, and you will see the following prompt in your terminal window. You can enter your preferred password for the root user. This will be the password you will use to connect to your database and perform all operations with MySQL. Next, MySQL asks you if you want to enable the . The validate password component helps you ensure that users of MySQL use passwords with minimum strength and characters. Validate Password Component This is super helpful for production loads where many users are using MySQL, and you want to force strong passwords for all the users. Feel free to use it for production environments, but I will skip it for this tutorial because I am assuming you are configuring MySQL for development and not production. So as a response to this question, I will type and press return. At this point, MySQL will ask you whether you want to keep the password you just entered for the root user or you want to set a new password. Since we want to keep the password we already assigned to the root user, type in in your Terminal and press enter. No No By default, MySQL creates anonymous users, and now it will ask you whether you want to remove the anonymous users. We can remove the anonymous users as we don't need them and reply to this prompt with a and press the return key. Yes Then you get a prompt asking whether you want to disable the remote login for the root user. We will go ahead and disable the remote access for the root user, reply to this prompt with a , and press the return key. Yes As the next step, you are asked if you want to remove the test database MySQL created. Reply to this with a as well, which should remove the test database. Yes Finally, you are prompted to reload the privileges table for all the changes to take effect. Reply to this with a and press the return key. Yes With this, we have successfully installed MySQL 8 using Homebrew. Now let's go ahead and create a new database. Step Five: Create a New Database To create a new database with MySQL, we need to sign in as a root user to MySQL in our Terminal. To sign in as a root user, use the following command: mysql -u root -p Once you use this command, you will be prompted to enter your password. Enter the root password you created during the installation process. Once you enter the password, you should be logged into MySQL, and your terminal prompt should now show like so: mysql Once you see the above prompt, you can create a new database using the following command. CREATE DATABASE db_name;
// db_name is the name of your database; name it whatever you want to You should get the following response from MySQL: Query OK, 1 row affected (0.01 sec) That's it; you have a new database that you can use with the as the username and password assigned to the root user. root Subscribe 🙏😊 If I could help you, consider subscribing to , where I keep posting in-depth tutorials, and all stuff is edutainment for software developers. You can also follow me on Hashnode; here is my profile handle @ . Leave a like if you liked the article; it keeps my motivation high 👍. Cloudaffle, my YouTube Channel Cloudaffle Also published . here

The code in this story is for educational purposes. The readers are solely responsible for whatever they build with it.

Apple

Intel

Super

YouTube

The Impact of Linux and the GNU Project

Introducing the Satisfies Operator in TypeScript

Download My JavaScript CheatSheet

Read My Stories

Too Long; Didn't Read

How to Install MySQL 8 on macOS Using Homebrew

How to Install MySQL 8 on macOS Using Homebrew

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

14 Reasons Why Laravel Is The Best PHP Framework!

10 Ways to Optimize Your Database

10 Ways to Reduce Data Loss and Potential Downtime Of Your Database

10 Principles of Proper Database Benchmarking

10 Minute Guide to Fixing Damaged SQL Databases - No Recovery Required!

10 Best Online Courses to Learn Oracle and PL/SQL for Beginners

14 Reasons Why Laravel Is The Best PHP Framework!

10 Ways to Optimize Your Database

10 Ways to Reduce Data Loss and Potential Downtime Of Your Database

10 Principles of Proper Database Benchmarking

10 Minute Guide to Fixing Damaged SQL Databases - No Recovery Required!

10 Best Online Courses to Learn Oracle and PL/SQL for Beginners

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps