How to Install MySQL on Mac using Homebrew

[@kithowlett8374]

Fantastic tutorial - straight forward and too the point. Thank you!

[@DatabaseStar]

Thanks, glad you liked it!

[@newsewcamis]

thank you so much!!! two days here until this video !!!

[@DatabaseStar]

Glad I could help!

[@EboniBrown-u5w]

This tutorial was extremely helpful!

[@DatabaseStar]

Glad it was helpful!

[@janeenVarin]

Super helpful, thanks!

[@DatabaseStar]

You're welcome!

[@marinaQA]

Thank you so much :) It's very helpful

[@DatabaseStar]

You’re welcome!

[@TheTalisman1981]

Your video was very helpful. Thanks a lot. 🙂

[@DatabaseStar]

Glad it was helpful!

[@radhikakumarimittal441]

Hi i m not able to download mysql using brew its showing: “ No available formula with the name "mysql". ==> Searching for similarly named formulae... Error: No similarly named formulae found. ==> Searching for a previously deleted formula (in the last month)... Error: No previously deleted formula found. ==> Searching taps on GitHub... Error: No formulae found in taps.” what should i do.

[@DatabaseStar]

Hmm I remember getting this error once but I forgot what the solution was. I would suggest Googling for No available formula with the name "mysql".

[@yashikabarange550]

It works great!! Thanks

[@DatabaseStar]

Great to hear!

[@yorihyakuju9275]

thkx for tutorial , when i " brew services start mysql" i have this error message "Error: Formula `mysql` has not implemented #plist, #service or installed a locatable service file"

[@DatabaseStar]

Oh I’m not sure how to solve that one unfortunately

[@kiNs_RK-RBF]

thank you so much. your video is just perfect. well structured better accent, and result oriented. I've been trying to install mysql watching others videos and they are not as detailed as this. thank you again. but have one more issue; I successfully installed all- mysql, server, and workbench, but now the workbench can't work as it says my Os is Mac OS big Sur 11. and it requires Mac OS big Sur 13... please I'm stuck here. and Installation and setup have delayed my personal training for months...

[@DatabaseStar]

Glad the video helped! I did a quick Google and found that you could use older versions of MySQL Workbench with Big Sur, such as 8.0.24. Search for that on Google and you should see some results.

[@jugveersandher572]

When I type "brew install mysql". It is saying, no available formula with the name "mysql". I have Mac M1 Monetary btw.

[@jugveersandher572]

Is mysql no longer compatible with homebrew?

[@DatabaseStar]

Hmm, I just had a quick Google and it seems that mysql on homebrew is compatible with both the M1 and the older CPU, and recent versions of macOS (info here: formulae.brew.sh/formula/mysql) Perhaps you could try some of the steps suggested on some StackOverflow pages? Some of them mention running "brew doctor".

[@magicyue387]

Maybe try command: `brew doctor` , and then `brew update` to update the dependencies. After the done the above, type `brew install mysql`. Hope this will help! I am M1 mac as well, and I just installed it successfully!

[@travelwithaash]

Thank You 👌👌👌👌👌

[@DatabaseStar]

You’re welcome!

[@jenstaveirne6247]

Thanks! I just installed homebrew on my M1 Macbook Pro but when I try to do the step "brew install mysql" I get the notification "zsh: command not found: brew" Help?

[@DatabaseStar]

Oh that's odd. I think that error indicates that homebrew is not installed, but I don't know why it wouldn't be. I would suggest Googling the error, perhaps that can show a solution.

[@rachelbhoy9563]

thank you so much!!!

[@DatabaseStar]

You're welcome!

[@ak256ak]

Thanks a lot.

[@DatabaseStar]

No problem!

[@ashokrathod3450]

getting error : ➜ ~ mysql -u root zsh: command not found: mysql

[@DatabaseStar]

I am guessing you need to add mysql to your bash profile.

[@mrnobody4675]

Thank you

[@DatabaseStar]

You're welcome

[@shoumikdaterao5446]

Its throwing an error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[@DatabaseStar]

That error usually means the username and password are incorrect. Did you enter the details as mentioned in the video? If you did, then perhaps there's another issue (e.g. MySQL is not running).

[@abrarhussain2459]

once i run the homebrew comand on terminal it shows following message ==> Checking for `sudo` access (which may request your password)... Password: after this i am not able to type on terminal. I know the password but I can't type it. Whats the solution to this?

[@DatabaseStar]

What do you mean when you say you can’t type it? Perhaps the Terminal shows a prompt and when you enter the password the characters don’t appear on the screen, if so then this may be correct and the password will still be accepted.

[@abrarhussain2459]

@@DatabaseStar Yes characters were not appearing on the screen however I entered the password and pressed enter. Everything went smoothly then.

[@donhugorincon6785]

Thanks

[@DatabaseStar]

You’re welcome!

[@rudeadyet1992]

Gracias! :)

[@DatabaseStar]

You’re welcome!

[@manjunathangandhimadhi1345]

not able to connect with phpMyAdmin

[@DatabaseStar]

Oh what error are you getting?

[@juliettevila3640]

Thanks for your video but when i tried i got this error.: % brew services start mysql Bootstrap failed: 5: Input/output error Try re-running the command as root for richer errors. Error: Failure while executing; `/bin/launchctl bootstrap gui/501 /Users/ophelie/Library/LaunchAgents/homebrew.mxcl.mysql.plist` exited with 5.

[@DatabaseStar]

Oh I haven't seen that error before, so I'm not sure how it could be resolved.

[@pavlokochan3147]

me too

[@themanyoushouldknowabout]

When I tried to install the first time, I see the error in the terminal: Error: Failure while executing; `cp -pR /private/tmp/d20221216-27065-eqt35d/gdbm/. /usr/local/Cellar/gdbm` exited with 1. Here's the output: cp: utimes: /usr/local/Cellar/gdbm/.: Operation not permitted cp: chmod: /usr/local/Cellar/gdbm/.: Operation not permitted Any help?

[@DatabaseStar]

Oh, I've never seen that before. I am guessing because of the terms "cellar" and "chmod", it's something to do with the user not having permissions to modify folders and run the brew command.

[@kostiantynpliusnin7104]

I got very weird case: > brew services list Name Status User File mysql error 256 kostiantyn ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist so far > mysql -u root works good and I'm able to enter mysql console brew reacts as it should on brew services start/stop/restart mysql but when I stop it I'm able to 'mysql -u root' any way

[@DatabaseStar]

That is strange, I would assume you can't use mysql when it's not running.

[@kostiantynpliusnin7104]

@@DatabaseStar the only real error I can get is when I start mysql 2 times in a row. And error itself is weird also when I stop it I still can run mysql console and I still see it with `ps aux | grep mysql` here example commands I ran in a row > brew services stop mysql Stopping `mysql`... (might take a while) ==> Successfully stopped `mysql` (label: homebrew.mxcl.mysql) > brew services start mysql ==> Successfully started `mysql` (label: homebrew.mxcl.mysql) > brew services start mysql Bootstrap failed: 5: Input/output error Try re-running the command as root for richer errors. Error: Failure while executing; `/bin/launchctl bootstrap gui/501 /Users/kostiantyn/Library/LaunchAgents/homebrew.mxcl.mysql.plist` exited with 5. > brew services list Name Status User File mysql error 256 kostiantyn ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist brew services stop mysql Stopping `mysql`... (might take a while) ==> Successfully stopped `mysql` (label: homebrew.mxcl.mysql) > mysql -u root mysql> Thank you for response. I'll try to find some logs. And I'll post update if I'll be able to figure out what's wrong

[@ukpauchechi]

Thank you!!, this was very helpful.

[@DatabaseStar]

Glad it was helpful!

[@shrirambalaji2915]

Thank you

[@DatabaseStar]

You’re welcome!