How to Install MySQL on Mac

Tolu Adesina — Mon, 30 Sep 2019 13:55:20 +0000

First Check if you have MySQL installed on your Mac.

Type mysql in your terminal

If you have mysql there, you can get different types of messages, one that you might get is this one

Error 1045 (28000): Access denied for user 'username'@'localhost' (using password: NO)

This way you will know you have mysql installed, but if you get an error saying something like;

-bash: /usr/local/bin/mysql: No such file or directory

This way we know that mysql is not installed, we then go ahead to mysql.com to download the mac version.

click that link above — it already has mac version selected

Double click on the downloaded file.

Follow the installation process, and then when you get to the point where you are asked to create a password, make sure you do create a password you would remember.

Boom! Finish the process and be Happy!

...

That’s not all. that’s the first part!

...

Now that we have MySQL installed, let’s make sure it is accessible anywhere on the computer.

But before that, let’s just check to make sure it is working properly.

Open System Preference and click on MySQL logo

So now that we know it is working, let’s add the PATH, so we can use terminal to access MySQL from anywhere on our system.

Open Terminal
cd to root ~/

then run this command to see all the files you have, just to be sure you have .bash_profile file on your system.

so you run ls -al and then scroll till you find .bash_profile

If you do not have .bash_profile file, simply run touch .bash_profile and you would have created a file called .bash_profile

Now that we have .bash_profile we open it with the following command;

open -t .bash_profile

This way you open up the .bash_profile in the text editor and then you should add this line to the file;

export PATH=${PATH}:/usr/local/mysql/bin/

Now you should save the text file and then close the terminal instance.

Restart your terminal and then run mysql -u root -p in your terminal.

You should get something looking like this.

...

Now you can write your MySQL codes and be Happy! 😁

...

Thank you for your time. I hope you’ve enjoyed reading this article.

DEV Community: Tolu Adesina

How to Install MySQL on Mac