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.
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?
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.
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
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!!!!!
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.
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
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
@@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.
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)
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
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!!!!!
5 years later and still on spot! Thank you!
Thank you! You’re literally the best
Mike you have made programming look easy.
Extremely helpful. Thank you!
For you, to make life a bit easier :)
echo ‘export PATH=/usr/local/mysql/bin:$PATH’ >> ~/.bash_profile
THANH YOU MIKE T_T following several tutorials but none of them works, idk why, until this one
Thank you great videos!!!
You are the man, thank you
Thanks Mike!
good man you solved one problem for me thank you
you saved my day bro
Thank u so much!
can you make more advanced paid courses in SQL, Back end Developer with economical for students.
you teach so well.
thank you so much for all sql videos but i want to change font size in popsql ,i did'nt fegier it out
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.
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?
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?
Im having the same problem, did you figure it out?
Hi, I had the same problem. Here is the instruction how to do it ruclips.net/video/k2EtMqUNkm8/видео.html&ab_channel=SysAdminCorner
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.
Can you connect remotely to another DB with PopSQL?
Why did you recommend using POPSQL when we could have easily downloaded and installed MySQL workbench during the installation process
Hi there! I just encountered a problem when trying to connect to the database that is `Handshake inactivity time out. Can someone help me?
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
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!!!!!
pop sql is no longer free??you only have a free trail ? do you suggest others ?
is there a way to change your username?
How do I fix " Client does not support authentication protocol requested by server; consider upgrading MySQL client" ?
login to mysql, and use
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
worked for me.
perfect that worked, thank you so much
it doesnt open for me after the download
What if it doest not let you type in a password?
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.
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
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
Me too! Have you fixed that?
Check if you have started 'Mysql Server' on System Preferences
@@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.
check in here medium.com/@jangid.hitesh2112/install-apache-mysql-php-macos-mojave-10-14-b6b5c00b7de it works for me
it says the localhost is not found what should I do?
please! help me..
This may help discussions.apple.com/docs/DOC-3083
bash_profile doesn't work so what now?
If you're having issues getting to the terminal where you can enter a password, use this video:
ruclips.net/video/nCrSHg53Llc/видео.html
it says my password doesn't work??
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)
hi i am getting this error when entering info at popsql Uh oh :( getaddrinfo ENOTFOUND localhost
it says :
-bash: .~/.bash_profile: No such file or directory
Can anyone help?
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
@@sosetavsciorap thank you
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
i have the same issue. were u able to resolve yours?
Anyone else not get a password?
I didn't. I made my own.
@@motorheadbanger90 how did you do that?
@@TheArmanster I was prompted to...
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!!!!!