MySQL Mac Installation | SQL | Tutorial 5

[@ranjanadissanayaka5390]

I'm always watching your videos to refresh my memory

[@albinite]

5 years later and still on spot! Thank you!

[@ugochukwu8270]

Mike you have made programming look easy.

[@Amazhit]

For you, to make life a bit easier :) echo ‘export PATH=/usr/local/mysql/bin:$PATH’ >> ~/.bash_profile

[@taweikadil511]

Thank you! You’re literally the best

[@Siddharth-uo6zw]

Thank u so much! can you make more advanced paid courses in SQL, Back end Developer with economical for students. you teach so well.

[@Kijiima]

Hi Mike - helpful tutorial! But I have a OS 11.2 Big Sur and I can't seem to access MySQL through Terminal when following your instructions. Any chance you can help?

[@nathaliamendesdealbuquerqu3406]

Im having the same problem, did you figure it out?

[@dariamaecka230]

Hi, I had the same problem. Here is the instruction how to do it kzbin.info/www/bejne/oWOopYCnirOeo5o&ab_channel=SysAdminCorner

[@juandaRodriguezO]

I had the same issue when installing it in Big Sur. I was able to fix it by downloading the 8.0.28 version (the MySQL website has it as the one for Big Sur) after that, follow Mike's steps and I should work.

[@biesann9329]

THANH YOU MIKE T_T following several tutorials but none of them works, idk why, until this one

[@lorraineliu8422]

Extremely helpful. Thank you!

[@labbdogg2929]

Why did you recommend using POPSQL when we could have easily downloaded and installed MySQL workbench during the installation process

[@miyemba_14]

you saved my day bro

[@mscoco1431]

thank you so much for all sql videos but i want to change font size in popsql ,i did'nt fegier it out

[@armmass5036]

good man you solved one problem for me thank you

[@gaberondon8757]

You are the man, thank you

[@flopac2776]

Hi Mike, unfortunately the download of POPSQL is not for free anymore. Is there a way how I can download it without the monthly costs?

[@sureshmhoprekar2744]

Thank you great videos!!!

[@emmavelazquezxyz]

Thanks Mike!

[@Roboticdock]

Mike, thanks a lot for nice explanation, I have trouble connecting POPSQL! Actually, when I sign in, it doesn’t open the “connecting to database” window, instead it takes me back to the application. I’d be grateful if you could help me.

[@kengthe5949]

Hi there! I just encountered a problem when trying to connect to the database that is `Handshake inactivity time out. Can someone help me?

[@khooskzad5612]

Can you connect remotely to another DB with PopSQL?

[@javiercruz3789]

MIKE DANE I need your help! I am watching all your videos and learning about SQL. I am stuck at this MySQL Mac Installation Tutorial 5. I dowloaded MySQL to my MacBook Pro but it's not coming up on my screen and neither is going to "terminal" and writing out the command.I hit enter after writing the command and it does nothing. Please help me or anyone. I been at this for days, I want to learn this and practice. I am not giving up, hope you read this and help!!!!!

[@xinyue3317]

pop sql is no longer free??you only have a free trail ? do you suggest others ?

[@christroy5216]

How do I fix " Client does not support authentication protocol requested by server; consider upgrading MySQL client" ?

[@juliaguzheng]

login to mysql, and use ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; worked for me.

[@christroy5216]

perfect that worked, thank you so much

[@rajroy6215]

it doesnt open for me after the download

[@renymarinez6900]

What if it doest not let you type in a password?

[@abukarabukar5193]

bash_profile doesn't work so what now?

[@LakeCountyWindowCleaners]

If you're having issues getting to the terminal where you can enter a password, use this video: kzbin.info/www/bejne/pHTVhHudaph_osU

[@traveltoegypt]

Hi Mike, Thank you for the great stuff you offer every time. I get the following error while trying to access mysql {-bash: .: /Users/islam/: is a directory } any clue? Thanks a lot

[@insideyourcloset2725]

is there a way to change your username?

[@mitchellhayes4410]

trouble getting mysql to set up in my terminal on a mac, $ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) is the response i am getting, any solution would be greatly appreciated

[@halineferreira]

Me too! Have you fixed that?

[@krchirla]

Check if you have started 'Mysql Server' on System Preferences

[@abdulwadood6927]

@@krchirla actually same error as above and checking on pref pane the instance keeps starting and stopping by itself - as in toggles b/w start and stop (for both Active and Installed instance). Also in configuration section the configuration file path is empty. Reinstalled multiple times. Checked, other and data directory path and file exists.

[@MrKevien12]

check in here medium.com/@jangid.hitesh2112/install-apache-mysql-php-macos-mojave-10-14-b6b5c00b7de it works for me

[@greatboredompineappl]

it says my password doesn't work??

[@justthatpm]

hi wondering if you'd be able to help me out. download mysql server but having issues with the root password. i set it during the installation but when trying to setup the command line it's saying incorrect password. im on mac ox sierra.

[@mitchellhayes4410]

similar issue, also on a mac, $ mysql -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) is the response i am getting i hope you had better luck that i did Irma, any solution would be greatly appreciated

[@zamiramiri4784]

it says the localhost is not found what should I do? please! help me..

[@emmavelazquezxyz]

This may help discussions.apple.com/docs/DOC-3083

[@utkarshsachaan]

Can anyone suggest how to navigate this error after mysql -u root -p ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[@andychang2739]

Anyone else not get a password?

[@motorheadbanger90]

I didn't. I made my own.

[@BeatSeedz]

@@motorheadbanger90 how did you do that?

[@motorheadbanger90]

@@BeatSeedz I was prompted to...

[@shahbazsandhu]

hi i am getting this error when entering info at popsql Uh oh :( getaddrinfo ENOTFOUND localhost

[@utkarshsachaan]

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[@hectorquaicoe8215]

i have the same issue. were u able to resolve yours?

[@mahinike16]

it says : -bash: .~/.bash_profile: No such file or directory Can anyone help?

[@sosetavsciorap]

If you already set a password while doing the installation, type this instead and it should log you in mysql: sudo /usr/local/mysql/bin/mysql -u root -p

[@hieunguyentrung2844]

@@sosetavsciorap thank you

[@javiercruz3789]

MIKE DANE I need your help! I am watching all your videos and learning about SQL. I am stuck at this MySQL Mac Installation Tutorial 5. I dowloaded MySQL to my MacBook Pro but it's not coming up on my screen and neither is going to "terminal" and writing out the command.I hit enter after writing the command and it does nothing. Please help me or anyone. I been at this for days, I want to learn this and practice. I am not giving up, hope you read this and help!!!!!