How to Install MySQL on macOS (using a DMG File)

Installing MySQL on a Mac is pretty straightforward, but there are a couple of things to be aware of. There are two ways to do it: the DMG method and the Homebrew method. This video uses the DMG method.

You may also get a “mysql command not found” when you try to connect to the database.

In this video, you’ll see how to download MySQL, install it, resolve that “mysql command not found” error, connect to the database, and run some simple SQL.

If you want to go further, you can install MySQL Workbench as well. I’ll have a separate video for that.

Timestamps:
00:00 What’s in this video
00:39 Download MySQL
02:43 Install MySQL
04:13 Check MySQL is running
04:45 Connect to the database using terminal
05:17 Resolve “bash MySQL command not found” error
06:53 Connect and test

[clipsbyczar]

Somehow you are the only person to show how to set up servers with 0 confusion. I appreciate you so much.

[leticia.]

This video literally saved my life!! Been trying to install it for quite some time and couldn't make it work, but your tutorial guided me through every step. Thank you so much for this video!!

[tuan.hoang_]

Thank you for the detailed walkthrough. I came across your video because I couldn't figure out why typing "mysql" in the terminal didn't work. So I guess the installer doesn't add the binary location to the PATH variable.

A little suggestions, I think you can just put "/usr/local/mysql/bin" to the PATH, because there's a symlink in "/usr/local" that points directly to the "mysql-8.0.28-macos..." folder.

[melissasibihwanamugoya]

Hi, I run the path configuration of bash profile but command not found error persists. I got the exact error you got at 6:53 when you rerun the mysql -u root -p command. my terminal is running zsh, what should I do? Already tried the suggestion in one of the comments that says run open - e .zshrc instead. I wasn't.t sure where to place the configuration line so I placed that at the bottom, saved and rerun the sql root command. same issue arises. Please help! not able to do any of my work.

[FreePalestineForever-free]

Everything went well until the terminal step, in the first method I got a message that such file doesn't exit, same for the bash profile, what should I do ??

[sabrinahe]

I did exactly what were said in this video but installation got stuck and it could not progress to Maybe I should try Homebrew.

[hudamg]

I have an issue, I followed your steps but at the end of installing it gets stuck and stays for hours saying "Install time remaining: Less than a minute". Can you please tell me why this is happening and what I need to fix?

[DrSeanKennedy-kb]

Great video - nice and simple. Easy to follow. Thanks very much!

[devangshukla]

love u bro...u best...my career started because of u

[genesis]

I'm sorry but when I do the .bash_profile part on 6:30 it’s still saying not found

[jordanrowland]

Thank you, this was very clear and succinct and helped a lot

[humairaaakthar]

When I write the name of the MySQL tool or try to open .bash_profile, neither work by saying no such file and .bash_profile does not exist.

[benjcheah]

Thank you so much for your wonderful and simple to understand explanation. U r da man!!

[maihoang-pgcx]

Thank you so much for posting this amazing video, it helps me so much with my homework

[juliettevila]

Merci beaucoup pour cette vidéo. J'étais tellement habituée à utiliser les containers Docker que votre vidéo a était super utile, et vous expliquait très bien. Je vous remercie.

[thaihuns]

I keep getting an error pop-up that the ".pkg" cannot be opened because it is from an unidentified developer. There is no allow option. I have tried all possible solutions that I could find on the internet including trying "Open Anyway" from under security settings which doesnt do anything as I get the same error message when I click on Open Anyway. Suggestions please?

[sangtt]

This video is helpful for me. Thanks for your sharing

[wicakradityo]

very good tutorial, i appreciate it mate.

[tostoncito]

I followed your steps but when running 'mysql -u root -p' I get this message 'ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)'. I am inputting the password correctly, what might be the issue?

[ClayVogt]

So, I'm very new to databases & programming, and downloading to teach myself more. The problem I'm having following this tutorial is that I'm not running bash. I'm running zsh. where do I find my .zsh profile to set my path?