so we have to follow your instruction in this video " How to Install MySQL on Mac" before this very one "How To Connect to MySQL Database in Visual Studio Code and Run SQL Queries | MySQL in VSCode (2024) "?
@@WHO_AM_1X my connection is built successfully but after 2-3 hours it is deleted automatically and not showing in VS code .. As i made it again but shown error that server time gone
Simple... 1) install the mysql server from the mysql installer... select the option (server only) in the installer, and set the root password while installing. 2) after installing login to your server using command prompt, you need to give the username as 'root' and password should be the root password that you gave while installing mysql. 3) create a database using the sqlquery directly from command prompt. after creating the DB exit from command prompt. 4) provide the name of the same DB that you created that you created using Command prompt, in the Database field as shown in the video.
@@fedinchukv yes. Whole proceedure in this video must do after installing sql shell in your pc or simply install mysql from mysql website then go through this video... I did this after installing mysql...
Same i have problems with connection timeout record limit how i solve? And the message is the client option ‘pooling.maxldle Time’ does not support value ‘NaN @programming
Same i have problems with connection timeout record limit how i solve? And the message is the client option ‘pooling.maxldle Time’ does not support value ‘NaN @programming
how to create a database here, i want to learn sql and i am using my company laptop which do not allow me to install any software except vs code, so how can i start.
Thank you, I have a question, after I had written the code for create table, I expected that there should be only one file like yours, which is users, however, I found very many files such as innodb_table_stats, help_keyword e.t.c they are very many. The users table was in between many of them. What should I do?
Error opening connection Unknown database 'employee'............ I am getting like this while setting mysql setup in where demo text was entered in connection assessment video at 5.25 point how to solve it...
I have Created a Student result management system using c language and i want to store student's data in mysql server . If anyone knows how to do it then please tell me. I watched many videos but I didn't understood.
sir pls help me to fix error connection. I followed up what you taught in youtube, I fill up all literally but when I finished I tried to click connection I've got shock. Please answer me how to solve that error connection. Have a nice day sir.
maybe you haven't created the db yet. Just try running on terminal mysql or any other db community server that you installed, and then create the db with the command create database **name of the database**
i got error like {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"xprotocol","enableSsl":"Disabled"}}},"name":"Error"} what is this..?
How to Install MySQL on Mac - ua-cam.com/video/ODA3rWfmzg8/v-deo.html
thank pro haw to link my sql server on mac m1 in vuistal stuidio on utm windows 11 ?!
so we have to follow your instruction in this video " How to Install MySQL on Mac" before this very one "How To Connect to MySQL Database in Visual Studio Code and Run SQL Queries | MySQL in VSCode (2024) "?
So we need to install MySQL also?
Alwyas these Indians helping us with computers. Thanks man! 😉
I wasted my time in many videos and this is the best one with all the updated details about this topic
I didn't add a 0 to my port number to connect to my local database and it worked.
Can you make a video on how to install the database "demo" I really struggle to connect because I do not have a demo installed ?
Thnak you so much . I have set up my connection and everything is going well .
Hello bro, ye database me kya hoga??
Hlo
I will thank you for your help, I was following you a years ago and from you I learned Java and javafx .
How do I create a database previously when I connect to a MySQL database in Visual Studio? I'm referring to the 5:30 minute mark in this video. ASP
Same problem
If anybody has answer just let me know?
@@vaibhavtomar4208 facing same problem, and i spent lot of time on mysql it has many issues
@@WHO_AM_1X my connection is built successfully but after 2-3 hours it is deleted automatically and not showing in VS code .. As i made it again but shown error that server time gone
Simple...
1) install the mysql server from the mysql installer... select the option (server only) in the installer, and set the root password while installing.
2) after installing login to your server using command prompt, you need to give the username as 'root' and password should be the root password that you gave while installing mysql.
3) create a database using the sqlquery directly from command prompt. after creating the DB exit from command prompt.
4) provide the name of the same DB that you created that you created using Command prompt, in the Database field as shown in the video.
@@WHO_AM_1X When choosing location, just brings up file explorer and does not allow me to do anything in it?
I can't connect my MYSQL, port is having an errror. Is there anything available ports for MYSQL?
For the people who got the "server is gone away" error, I solved it by setting the Authentication Protocol to default.
got the same issue and solved it the same way. why this error tho?
@@tr1nityyyy Yes
connect ECONNREFUSED ::1:33060 this error coming while testing connection
Did you manage to solve it?
@@fedinchukv yes. Whole proceedure in this video must do after installing sql shell in your pc or simply install mysql from mysql website then go through this video...
I did this after installing mysql...
Same i have problems with connection timeout record limit how i solve? And the message is the client option ‘pooling.maxldle Time’ does not support value ‘NaN
@programming
@@Abubakar-IsmailHave you done it yet?
m.ua-cam.com/video/ODA3rWfmzg8/v-deo.html
Thank you very much. Very helpful video!
There is an error in the port, I am unable to connect...
Even i am also
That sucks
I am also faced
Also me
Also me
You're the best sir!
Thanks for the video. Helpful indeed.
Life Saver!
Really Helpful thank you
very useful and helpful, thanks bro
thanks for the video brother ........
Thank you very much
thanks really appreciated
very usefull video thanks sir
Same i have problems with connection timeout record limit how i solve? And the message is the client option ‘pooling.maxldle Time’ does not support value ‘NaN
@programming
Thank you very much !
how to setup a database previously?
In your terminal type MySQL -u root -p and type password and then write Create database ;
Didn't get this@@sumanth94
perfect video
so helpful, thank you
7:20 it says error opening connection error how can i fix it ?
how to create a database here, i want to learn sql and i am using my company laptop which do not allow me to install any software except vs code, so how can i start.
Please , i need help, when i execute Query, i get : no active connection found.
But , there is a green dot at the left on my "CONNECTIONS"😢
What will happen if the database name does not pre-exist in MySQL?
were you able to come over this issue?
i just created a database using the mysql command line client and then connected via this method
Thanks😇
Thank you for your tutorial. Is it designed for Visual Studio Code 2024, and is it possible to create and run stored procedures as well?
Thank you
Thank you, I have a question, after I had written the code for create table, I expected that there should be only one file like yours, which is users, however, I found very many files such as innodb_table_stats, help_keyword e.t.c they are very many. The users table was in between many of them. What should I do?
thanks!
How do we create database?
Can I use XAMPP to connect the MySQL server? If I can, how?
Bro it showing user settings error in my vscode
when i try to connect the server is gone away
same issue
I dont able to connect the test connection got error
What is the keyboard short cut to run queries in windows
You are amazing, thank you
after creating a sql on vs how to connect it to my html/css website without using php? please help
can we use it run our projects
@programmingknowledge bro in port we tried 3306 and 33060 are not working can you tell us why
What driver i need to install for SQL?
Sir, how do you use this with Python language? Do you have link?
any body tell me whats the error of this "ECONNRESET"
same problem
Error opening connection Unknown database 'employee'............ I am getting like this while setting mysql setup in where demo text was entered in connection assessment video at 5.25 point how to solve it...
While I test connection,it shows an error like unknown database.How to solve this
did you solve the problem? i got same message
I have Created a Student result management system using c language and i want to store student's data in mysql server .
If anyone knows how to do it then please tell me. I watched many videos but I didn't understood.
I will to know or I can connect m'y application in PDO After this installation
Hi brother, do offer training course
I have problem unknown daabase demo can u solve my issue?
what should i enter in connection group
There is an error when I test the connection
For me also,what's the way to overcome this?
There is an error in test connection, how to rectify?
sir pls help me to fix error connection. I followed up what you taught in youtube, I fill up all literally but when I finished I tried to click connection I've got shock. Please answer me how to solve that error connection. Have a nice day sir.
What if it gives us a connection error? What should we do in that case?
Can someone help me?
It is showing code language not supported what to do now??
Is there any way to import data in this as in workbench we have data import wizard please tell
bro import data in mysql and call in visual studio
@@patansadathalikhan2350 i got this idea only but i was like if there is something in it too
In my pc it is showing "Unable to write file (FileSystemError).. Help me please
what is the "Unknown database ---- " after i tested connection?
maybe you haven't created the db yet. Just try running on terminal mysql or any other db community server that you installed, and then create the db with the command create database **name of the database**
connection ni bnn rha mera error aa rha ha bar bar
thora smjha den k error kis kis waja se aa sakta ha ta k me crosscheck krr lu
please reply!!
Please make same video for Ubuntu OS
it's showing connect ECONNREFUSED ::1:3306
plz help me
same
Same
try to remove the last 0
still the same
@@farhitas3294
Can someone help, I get the message the serve has gone away when I test the connection
Access denied for user @ localhost (usinh password: YES) error
can anyone help me?
after testing connection it shows just "error"
Access denied for user admin@localhost using password yes ,this the error I'm getting on pressing test connection button
connect ECONNREFUSED 127.0.0.1:3306 how to solve?
connect ECONNREFUSED . Please Help
i cant connect it idk why is it a password problem?
why mine is error when test cnnection :(
How can we delete the tables?
Delete all rows in the table
Delete from user(your table name);
@SurathulEmenaU I just used DROP TABLE xD
i got error like {"code":-1,"data":{"driver":"MySQL","driverOptions":{"mysqlOptions":{"authProtocol":"xprotocol","enableSsl":"Disabled"}}},"name":"Error"}
what is this..?
did u find out
Access denied for user 'root'@'localhost' (using password: YES)
i'm getting this error
How to create database
Connect ECONNREFUSED;;1:33060 unable to connect database could you please help me sir
remove the last 0
@@farhitas3294still didn't worked
@farhitas3294 I removed 0 but still showing error
Hello there @navaneethan.g6699
Did you solve it? I'm still trying to figure out how to get solve it.
Same
I am getting
Access denied for user 'admin'@'localhost' (using password: YES)
Its showing the error - The server has gone away.. Help anyone???
my NuGet Manager did not work as it meant the database didn't work entirely
error
give error
getting connection error
Same
not working for me
password?
Please provide password
Password
@programmingknowledge.
i got connection error
This isn't working for me, I keep getting Error on test connection
I didn't add the 0 at the end of the port number
Connection error
why mine is Error?