I had the same issue. The solution is this, open “Windows services” or “Services” app > find the service name “MySQL80” (name maybe different) > right click and select ‘Start’. Open MySQL Command Line App and enter your password, Now try and reconnect on PopSQL
Hi, I didn't find a video on setting up PopSQL. I'm trying to enter the username/password but it's not going thru for me. Is there any way you can help?
I have resolved the issue for future boys and girls (Windows Only) on your search bar type MySQL installer- community. then find the server and click configurate. then click the steps and enter your password. next open up the MySQL client and enter password. then go back to PopSQL and on the top left click the red wiggly cables and connect to the server you had created.
ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5
"windows" >> code is not running, getting a “permission denied for schema public” error message however I wrote >>> CREATE TABLE student ( student_id INT PRIMARY KEY, name VARCHAR(20), major VARCHAR(20) ); Please Support
@@gaganbajoria7515 im working now with MS SQL clean, better and without errors so I advise you about it and if you are going to continue in data analysis field text me by your mail and we can study together , I'm searching for someone to study together!!
Are you trying to use PopSQL? I had a hard time with that so I used MySQL Workbench. Slightly different interface, but much less headache connecting to the local MySQL server.
Hi Mike, I've already installed MySQL & POPSQL like the way you teached for windows ver. However, the botton "Run" in PopSql doesn't highlight and work. I can't execute my texts. Please help me to solve that above problem! Thank you so much!
Hey bro, i know its late but in windows, enter to popsql and on top of the text in would say Mysql with some cables there, click it and it becomes green, thats how you connect to the database :)
I have resolved the issue for future boys and girls (Windows Only) on your search bar type MySQL installer- community. then find the server and click configurate. then click the steps and enter your password. next open up the MySQL client and enter password. then go back to PopSQL and on the top left click the red wiggly cables and connect to the server you had created.
hey , i can"t connect my popsql to mysql server it gives me this message (Uh oh :( ER_ACCESS_DENIED_ERROR: Access denied for user 'root '@'localhost' (using password: YES)) pleaaase , any help
Thanks a lot for this playlist Mike! Excellent job! Very clear and useful! Greetings from Russia :-)
Sir! your teaching is really beneficial! Thanks a lot for this course here! Lots of love and gratitude!
bro this tutorials are sooo easy to catch, good job.
Loving this video! Thanks so much for the playlist.
I am start lerning the SQL by myself and I found your channel. Thank you very much. (subscribe already).
I think after 2 yrs u have mastered.....Isn't it ??????
such a well thoughout video! thanks for sharing
Outstanding 😍 .. happy to be a member in your channel 🙏
So far, no comment. I enjoyed the lecture! Thank you so much guy!
Great content man and very well explained
thank you Mike. Keep creating videos:)
you the best. I feel like a programmer now
Thank you very much. Your video helped me to finish my homework. Very helpful.
awesome video bud. Thank you
love this playlist dude. So indepth, really helping me out
How do I get the MySql workbench?
GREAT VIDEO!! THANK YOU!
Thank u so much!
can you make more advanced paid courses in SQL, Back end Developer with economical for students.
you teach so well.
So amazing,i feel like a programmer now than before
Definitely helped me with breakdown of codes, meanings etc! thank you!!
your videos are helpful
Perfect video
So good tutorial
Hi Mike,
How can I change the default date format?
hi can i ask if its necessary to install popsql to get along with this tutorial or I can use the built in mySql workbench as the text editor?
Thanks a lot 😍😍
Hi welcome to SQL. Did you happen to bring your right parenthesis?
Gonna rewatch this video tmr. hm
✅
hey mike, I installed popsql but am finding it hard connecting back to my database after I shutoff my machine.....any hints
same problem bro , please what was the solution ?
I had the same issue. The solution is this, open “Windows services” or “Services” app > find the service name “MySQL80” (name maybe different) > right click and select ‘Start’. Open MySQL Command Line App and enter your password, Now try and reconnect on PopSQL
Hi, I didn't find a video on setting up PopSQL. I'm trying to enter the username/password but it's not going thru for me. Is there any way you can help?
ruclips.net/video/iPgIBRVFG14/видео.html watch this tutorial, he has explained it in detail.
sqlfiddle.com is useful way to try out sql if you don't want to download a program
Are you guys having some issues with new popsql version? I can't connect it to mysql and open the database...
SAME
Am getting error bad URI, where could I be getting it wrong? please assist.
I see you as my God.
geez bruh chill out
thats right, that how i see him too haha, thanks to him i learned python and Sql
I have resolved the issue for future boys and girls (Windows Only) on your search bar type MySQL installer- community. then find the server and click configurate. then click the steps and enter your password. next open up the MySQL client and enter password. then go back to PopSQL and on the top left click the red wiggly cables and connect to the server you had created.
Mike, I did exactly what you wrote but all I got was an error 1046. Please help me
ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5
CREATE TABLE student (
student_id INT NOT NULL,
name VARCHAR(20),
major VARCHAR(20),
PRIMARY KEY (student_id)
);
RUN THIS CODE for MySQL 8.0
@@HarshKumar-tw3st Thanks bro!!!
"windows" >> code is not running, getting a “permission denied for schema public” error message however I wrote >>>
CREATE TABLE student (
student_id INT PRIMARY KEY,
name VARCHAR(20),
major VARCHAR(20)
);
Please Support
Same problem :(
Hey i found out my mistake. You filled the wrong details while linking the database in PopSQL app. Check the name of the database once
@@gaganbajoria7515 im working now with MS SQL clean, better and without errors so I advise you about it and if you are going to continue in data analysis field text me by your mail and we can study together , I'm searching for someone to study together!!
MY POPSQL KEEPS QUERYING
Uh oh :( Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Are you trying to use PopSQL? I had a hard time with that so I used MySQL Workbench. Slightly different interface, but much less headache connecting to the local MySQL server.
Scott Isitt ya I switched to workbench, its so much better. Initial setup is long but worth it
@@alenjose3903 Right on. 👍
Hi Mike,
I've already installed MySQL & POPSQL like the way you teached for windows ver.
However, the botton "Run" in PopSql doesn't highlight and work. I can't execute my texts.
Please help me to solve that above problem!
Thank you so much!
Make sure your mysql server is running. Im not sure how to do this in windows, in Mac it appears on the front page of settings
I am facing the same issue, Did you resolve it?
Hey bro, i know its late but in windows, enter to popsql and on top of the text in would say Mysql with some cables there, click it and it becomes green, thats how you connect to the database :)
I have resolved the issue for future boys and girls (Windows Only) on your search bar type MySQL installer- community. then find the server and click configurate. then click the steps and enter your password. next open up the MySQL client and enter password. then go back to PopSQL and on the top left click the red wiggly cables and connect to the server you had created.
not working for me, help
hey , i can"t connect my popsql to mysql server it gives me this message (Uh oh :( ER_ACCESS_DENIED_ERROR: Access denied for user 'root '@'localhost' (using password: YES)) pleaaase , any help
hello bro ... r u solve ur issue .?????
i have the same problem bro .. pls help me man....
Normal people don't have a name with a thousand characters 😂😂😂😂😂😂😂
Need help
permission denied for schema public LINE 1: ...8b605e0-bfba-11ec-95c7-75b6cd374c80*/ CREATE TABLE student ( ^
HELP ME
@@dixitgupta4679 are you found the sulution ?
@@abdallahmohammed3060 nope
5 and a half minute for anything useful