Hey mate! Thanks for the video. It helps =) However, when I click "add connection", nothings shows up and VS Studio keeps searching for packages. How to get around this issue? Thanks!
Dont forget to mention in the part where you enter Username, it has to be a user from the XAMPP list. 'user@localhost' etc. I was getting query errors like wtf why is the query isnt working or the databast wasnt showing. Fixed now.
Thanks! Good explanation. Newbie here, and newbie question, is it necessary to use XAMP? I've instaled SQL Server on my machine, can I connect without using XAMP ?
Thanks for watching! XAMP is used to be able to open the mySQL database locally on your computer. Since, SQL Server is Microsoft technology and it can be installed and run on Windows then you don't need tools like XAMP. However, linking php to SQL Server is different story, as I think you need some other tools or so. Unfortunately I don't have a video about that!
I guess you've already solved this thing. But I think it would be useful for you to get into Docker containers. You can run a lamp stack without installing php or mysql in your machine
You must have a server to be able to connect to, using the extension! For testing purposes, you can have a local server installed on your computer (XAMPP installation provides you with a MySQL server). But the server can also be online, provided to you by your hosting provider. So to be short, you must have some kind of server to be able to utilize this extension!
I deleted my connection once because something gave an error, and now it won't show any connections when I make new ones. I tried deleting SQL and the SQLTools extension but nothing works. Is there a way to fix this?
Hi. do you know the hotkey to run query? It seems that in the video every time you need to run the query you always have to go to the command palette . Thanks anyway for the explanation.
If you haven't setup a keyboard shortcut/hotkey for that, then there isn't one! However, you can setup a keyboard shortcut in vscode for that command, which you can then use it to run the query!
Hello, May I use MySQL on VSCode in Ubuntu 20.04 operating system? I tried things that you showed bu at 1:10 second I can't see anything. It is told me that "Couldn't find any drivers installed yet. Search VSCode marketplace". Do you have a suggestion? Thanks!
Well, I am not sure for Ubunutu. I know that many were complaining about have the issue in Windows as well. Someone suggested to try to install older version of the extension, as the current one is not working properly. Maybe, that won't fix it for you, but you could give it a try!
I always us the most updated version. I don't recall which version was it, but the video was made around beginning of November 2019. By checking the VS code versions, it should be either version 1.39.0 or 1.40.0 !
If something doesn't work it is up to the developer, not me! I have not made the extension, I just show how it works! Obviously, when I made the video everything worked for me. See the pinned comment and you will find a solution that worked for someone. Installing an earlier version of the extension, might fix your issue! Btw the extension I show, work with MySQL only, not with MIcrosoft Server or any other engine. You might need to setup additional configuration to have it work, with other database systems!
@@TechVideoStack This extension that you used works fine sir dont worry, the problem I was trying to say was that before I found your tutorial, I was using another extension (the one from microsoft, MSSQL) thats not used for the MySQL database, so I did big mistake without knowing xD. I could not tell it the right way, my bad
Also my bad then, I thought you were having the same issue, as the most people trying to use this extension, due to a new update of the extension. Well, MSSQL works differently (has other requirements), while MySQL requires other ... that should be the reason it didn't work for you! But, I am glad it worked now ... happy coding and sorry for the misunderstanding! P.S. I think you can use this extension to connect to MSSQL too, with some adjusments, but I haven't tried it! I might make a video about it, in the future!
i have installed Mysql workbench and also Xampp, but when y tried to add a new connection it just tells me "Couldn't find any drivers installed yet.", what I should do? please
I did not install any driver in particular to see that option! I just have XAMPP installed. After installing the VS Code extension, everything worked fine!
@Tech VideoStack I AM FACING SOME PROBLEM IN CONNECTING PLEASE AND I WOULD NOT BE ABLE TO DOWNLOAD SQL ON MY MACHINE AND I DON'T WANT TO INSTALL THAT SO PLEASE HELP ME AND I ONLY HAVE XAMPP AND VSCODE HELP ME
@@TechVideoStack I ALSO USE PYTHON ON VSCODE AND WHEN I START FOLLOWING STEPS GIVEN IN YOUR VIDEO EVERYTHING IS GOING NICE BUT IN YOUR VIDEO AFTER YOU HAVE SAVED CHANGES IN YOUR VIDEO YOU GOT SOME TABLES BUT I DON'T GET THAT IN MY VSCODE SO PLEASE HELP ME
Well, you have to create the table using phpMyAdmin. It is very simple, and you can use whatever table you want, doesn't have to be the same, it is just as an example!
@@TechVideoStack HOW CAN I CREATE TABLE IN PHPMYADMIN CAN YOU TELL ME STEP BY STEP AND ALSO I WANT TO TELL YOU TAHAT I DON'T HAVE MYSQL ON MY COMPUTER AND I CAN'T INSTALL IT THATS WHY I AM USING OTHER METHODS FOR USING SQL PLEASE HELP ME AND THANKS FOR REPLYING I THOUGHT THAT YOU WILL NOT REPLY ME
I always try to reply to the questions of my viewers, so you are very welcomed 🙂 To see how to do that in the phpMyAdmin, you can check my XAMPP playlist, which shows you all the steps required. You will find a video there, that shows you step by step, on how to create a table in MySQL using phpMyAdmin. I don't know if you have tried to use the XAMPP package (which provides you with a PHP and MySQL (phpMyAdmin) environment for testing and learning purposes). If not, it would be good if you started using it. So, I suggest you to check the XAMPP playlist first, and see if it will help you with the issue and eventually in having success in completing this tutorial. Let me know if it helped!
i come up with this eror while connection, any one has a solution? Request connection/GetChildrenForTreeItemRequest failed with message: ER_ACCESS_DENIED_ERROR: Access denied for user 'rootroot'@'localhost' (using password: NO)
I have created the test database in XAMPP! I have a tutorial on how to create a simple database and a table in XAMP and MySQL! You can check it the XAMPP playlist!
Seems like there is an issue, with the recent extension update, by the creator. I see many are complaining about it. Tried to install it in a separate computer, but I get blank page, when creating a new connection. I believe, the creator will fix the issue, in the upcoming days ... If not, there is nothing I can do on that, as I am not the creator ... you could try to check for another extension that will work! I am sorry for the issue and not being able to help!
I have a error while connection,any one had solution plz request connection/getchildrenfortreeitemrequest failed with message:er_access_denied_error:acces denied for uses 'school@'localhost'(using password:yes) plz bro slove this
"You must create a MySQL user specifically to access the app. Create a user and set a password (do not leave the password null). Do not forget to give this user permission to be able to access the database and tables of app. I hope I have helped."
You need to use a programming language (for example PHP) and database system (MySQL). Just search for connecting to a MySQL database using PHP and you will get many tutorials. Currently, I don't have any that might help you!
If you haven't setup a keyboard shortcut/hotkey for that, then there isn't one! However, you can setup a keyboard shortcut in vscode for that command, which you can then use it to run the query!
It depends how you've set them up to be for your database, in my case they are: test and test123, but yours might be different. You have to set them up in your MySQL database using phpMyAdmin!
Seems like there is an issue, with the recent extension update, by the creator. I see many are complaining about it. Tried to install it in a separate computer, but I get blank page, when creating a new connection. I believe, the creator will fix the issue, in the upcoming days ... If not, there is nothing I can do on that, as I am not the creator ... you could try to check for another extension that will work! I am sorry for the issue and not being able to help!
Seems like there is an issue, with the recent extension update, by the creator. I see many are complaining about it. Tried to install it in a separate computer, but I get blank page, when creating a new connection. I believe, the creator will fix the issue, in the upcoming days ... If not, there is nothing I can do on that, as I am not the creator ... you could try to check for another extension that will work! I am sorry for the issue and not being able to help!
@@TechVideoStack I use mysql. I installed this Extension: SQLTools MYSQL/MariaDB . By search Extensions in Marketplace give this Extension identifer: mtxr.sqltools-driver-mysql.
For those who got blank
Now reverting back version is the solution...until bug fix by dev..
Install another version(old)...
Version of vs code or the extension?
Extension
Older version of
Sqltools
Very well, thanks for sharing. I'll pin your comment!
Hey mate! Thanks for the video. It helps =) However, when I click "add connection", nothings shows up and VS Studio keeps searching for packages. How to get around this issue? Thanks!
You are a life saver. Thank you for the upload. ❤ 💪
You're welcome! Glad it helped 😊
Dont forget to mention in the part where you enter Username, it has to be a user from the XAMPP list. 'user@localhost' etc. I was getting query errors like wtf why is the query isnt working or the databast wasnt showing. Fixed now.
Thanks man, i been searching all around for a video as this!
You're welcome! Very pleased that it was so helpful to you!
Thanks! Good explanation. Newbie here, and newbie question, is it necessary to use XAMP? I've instaled SQL Server on my machine, can I connect without using XAMP ?
Thanks for watching! XAMP is used to be able to open the mySQL database locally on your computer. Since, SQL Server is Microsoft technology and it can be installed and run on Windows then you don't need tools like XAMP. However, linking php to SQL Server is different story, as I think you need some other tools or so. Unfortunately I don't have a video about that!
@@TechVideoStack thanks!
I guess you've already solved this thing. But I think it would be useful for you to get into Docker containers. You can run a lamp stack without installing php or mysql in your machine
Question: is downloading the extension the same thing as installing a server? Or do I need to install a server before the extension can work?
You must have a server to be able to connect to, using the extension! For testing purposes, you can have a local server installed on your computer (XAMPP installation provides you with a MySQL server). But the server can also be online, provided to you by your hosting provider. So to be short, you must have some kind of server to be able to utilize this extension!
I deleted my connection once because something gave an error, and now it won't show any connections when I make new ones. I tried deleting SQL and the SQLTools extension but nothing works. Is there a way to fix this?
Hi. do you know the hotkey to run query? It seems that in the video every time you need to run the query you always have to go to the command palette .
Thanks anyway for the explanation.
If you haven't setup a keyboard shortcut/hotkey for that, then there isn't one! However, you can setup a keyboard shortcut in vscode for that command, which you can then use it to run the query!
@@TechVideoStack alright, thank you very much..
Check more PHP tutorials in this playlist: ruclips.net/p/PLrVlNmJhrkfraXsxahjpr4vXD9Lv_56oZ
Very nice explanation
Thanks for watching it!
I think I found a solution , install sqltools MySQL/mariadb it gives an option to add MySQL as new connection
Thanks for sharing it!
TQ so much 🤗
Hello,
May I use MySQL on VSCode in Ubuntu 20.04 operating system? I tried things that you showed bu at 1:10 second I can't see anything. It is told me that "Couldn't find any drivers installed yet. Search VSCode marketplace". Do you have a suggestion? Thanks!
Well, I am not sure for Ubunutu. I know that many were complaining about have the issue in Windows as well. Someone suggested to try to install older version of the extension, as the current one is not working properly. Maybe, that won't fix it for you, but you could give it a try!
@@TechVideoStack Thanks for quick response. I tried but it didn't work. I'll use windows
You are welcome!
Your tutorial is awesome. Thanks
Thanks so much 😊
hii
what if i already have a database in phpmyadmin ?
how do i access that through vscode ?
Install the extension and connect to the database by providing the server, database name and database user credentials
got it thanks!!!
You are welcome
Which version of vscode you're using in this video??
I always us the most updated version. I don't recall which version was it, but the video was made around beginning of November 2019. By checking the VS code versions, it should be either version 1.39.0 or 1.40.0 !
dude I was literally high trying to use MySQL, I tried using the MSS extension and It was not working (obviously lol).
Thanks alot! /:>
If something doesn't work it is up to the developer, not me! I have not made the extension, I just show how it works! Obviously, when I made the video everything worked for me. See the pinned comment and you will find a solution that worked for someone. Installing an earlier version of the extension, might fix your issue! Btw the extension I show, work with MySQL only, not with MIcrosoft Server or any other engine. You might need to setup additional configuration to have it work, with other database systems!
@@TechVideoStack This extension that you used works fine sir dont worry, the problem I was trying to say was that before I found your tutorial, I was using another extension (the one from microsoft, MSSQL) thats not used for the MySQL database, so I did big mistake without knowing xD.
I could not tell it the right way, my bad
Also my bad then, I thought you were having the same issue, as the most people trying to use this extension, due to a new update of the extension. Well, MSSQL works differently (has other requirements), while MySQL requires other ... that should be the reason it didn't work for you! But, I am glad it worked now ... happy coding and sorry for the misunderstanding!
P.S. I think you can use this extension to connect to MSSQL too, with some adjusments, but I haven't tried it! I might make a video about it, in the future!
i have installed Mysql workbench and also Xampp, but when y tried to add a new connection it just tells me "Couldn't find any drivers installed yet.", what I should do? please
For those who got blank
Now reverting back version is the solution...until bug fix by dev..
Install another version(old)...
@@TechVideoStack another version of what?
Old version of sqltools ... sorry for not specifying it!
There is a step missing. You need to install the driver for MySQL in order to see the MySQL option in the menu(min 1:10).
I did not install any driver in particular to see that option! I just have XAMPP installed. After installing the VS Code extension, everything worked fine!
how do i do that?
Same issue, and I have xampp
thank you sir, amazing tutorial!!!
You are welcome! Thanks for watching!
can i create databse and table from there?
How would I connect to folders/files I already have?
Thank you a lot for this but I hope you got some rest after this video.
I did! I got tired making a free video for you all to watch and learn for free :)
@Tech VideoStack I AM FACING SOME PROBLEM IN CONNECTING PLEASE AND I WOULD NOT BE ABLE TO DOWNLOAD SQL ON MY MACHINE AND I DON'T WANT TO INSTALL THAT SO PLEASE HELP ME AND I ONLY HAVE XAMPP AND VSCODE
HELP ME
What problems are you having exactly?
@@TechVideoStack I ALSO USE PYTHON ON VSCODE AND WHEN I START FOLLOWING STEPS GIVEN IN YOUR VIDEO EVERYTHING IS GOING NICE BUT IN YOUR VIDEO AFTER YOU HAVE SAVED CHANGES IN YOUR VIDEO YOU GOT SOME TABLES
BUT I DON'T GET THAT IN MY VSCODE
SO PLEASE HELP ME
Well, you have to create the table using phpMyAdmin. It is very simple, and you can use whatever table you want, doesn't have to be the same, it is just as an example!
@@TechVideoStack HOW CAN I CREATE TABLE IN PHPMYADMIN CAN YOU TELL ME STEP BY STEP
AND ALSO I WANT TO TELL YOU TAHAT I DON'T HAVE MYSQL ON MY COMPUTER AND I CAN'T INSTALL IT THATS WHY I AM USING OTHER METHODS FOR USING SQL
PLEASE HELP ME
AND THANKS FOR REPLYING
I THOUGHT THAT YOU WILL NOT REPLY ME
I always try to reply to the questions of my viewers, so you are very welcomed 🙂
To see how to do that in the phpMyAdmin, you can check my XAMPP playlist, which shows you all the steps required. You will find a video there, that shows you step by step, on how to create a table in MySQL using phpMyAdmin.
I don't know if you have tried to use the XAMPP package (which provides you with a PHP and MySQL (phpMyAdmin) environment for testing and learning purposes). If not, it would be good if you started using it.
So, I suggest you to check the XAMPP playlist first, and see if it will help you with the issue and eventually in having success in completing this tutorial.
Let me know if it helped!
i come up with this eror while connection, any one has a solution?
Request connection/GetChildrenForTreeItemRequest failed with
message: ER_ACCESS_DENIED_ERROR: Access denied for user 'rootroot'@'localhost' (using password: NO)
"grant all privileges on .To’root’@’localhost’ identified by’your password’with grant option;
flush privileges;"
@@TechVideoStack How to do that
i also got the same error
how to fix this @Tech VideoStack
I have written the solution above in the thread! Have you tried that?
to me, it doesn´t show my database test, only phpmyadmin. Can you help me?
Have you created the database and the table?
@@TechVideoStack assisti a sua playlist sobre XAMPP e vi que era o que faltava, obrigado
De nada. Estou feliz que ajudou.
Can you explain how can I put the query tab not to split the editor?and creates a new tab next to the editor?
How do you exactly want the query tab to show? Separated or?
I am fresher, and I am new I have no database or tables so what name I write in place of database and user name
is there any specific place to save the database such as C:\xampp\mysql\backup\phpmyadmin
It must go through the browser. To access the phpMyAdmin page, you need to provide the username and pwd!
Thanks! You make my day.
You're welcome 😉
the colection of database driver not appear in vs code What should I do
Seems to be an error with the extension ... we have to wait for the developer to fix it!
Thank you!
You're welcome!
How did you create the test database? Please explain
I have created the test database in XAMPP! I have a tutorial on how to create a simple database and a table in XAMP and MySQL! You can check it the XAMPP playlist!
thank youu ^^ u helped me alot
You're welcome 🙂
Add new connection is not working,,,, I mean when I click the add new connection it just blank
Seems like there is an issue, with the recent extension update, by the creator. I see many are complaining about it. Tried to install it in a separate computer, but I get blank page, when creating a new connection. I believe, the creator will fix the issue, in the upcoming days ... If not, there is nothing I can do on that, as I am not the creator ... you could try to check for another extension that will work! I am sorry for the issue and not being able to help!
@@TechVideoStack thanks for the reply can you suggest any method to run SQL database in vscode......
you want it to be visual or plain code?
@@TechVideoStack doesn't matter sir I just need it be working. I had a website and index.php, config.php and states.sql...........
thanks bro
Thanks for watching the video!
it gives me access denied , I do not know the reason
Please go through the
comments of the video. As I recall someone had your problem, and provided a solution!
I have a error while connection,any one had solution plz
request connection/getchildrenfortreeitemrequest failed with message:er_access_denied_error:acces denied for uses 'school@'localhost'(using password:yes) plz bro slove this
"You must create a MySQL user specifically to access the app. Create a user and set a password (do not leave the password null). Do not forget to give this user permission to be able to access the database and tables of app. I hope I have helped."
How to do it plz tell i using xamp in first time plz bro🥺
Search for how to create a database user in MySQL using XAMPP. It is hard to show you here and I don't have a video for that!
Tnx bro♥
Did it work? Have you tried?
Quick tip:
play in 2x speed for best experience...
thank me later 👍
Thanks for watching it!
how I can connect html file withe sql file?I am sorry for my many questions
You need to use a programming language (for example PHP) and database system (MySQL). Just search for connecting to a MySQL database using PHP and you will get many tutorials. Currently, I don't have any that might help you!
Thanks! :)
You're welcome! Thanks for watching 😊
how do i make a database?
cause i dont have one.
if anyone can tell me where to go i will do that
Check my XAMPP playlist, you have a video there on how to create a database and a table in MySQL
I wish there was a shortcut to run the code, I run A LOT of queries every single day and can't be wasting time on doing the query palette thing
If you haven't setup a keyboard shortcut/hotkey for that, then there isn't one! However, you can setup a keyboard shortcut in vscode for that command, which you can then use it to run the query!
I got blank so what should I do
My database do not show under connections
What is the username and password for the connection ??.
It depends how you've set them up to be for your database, in my case they are: test and test123, but yours might be different. You have to set them up in your MySQL database using phpMyAdmin!
@@TechVideoStack Tq bro
You're welcome!
Hi Sir how to run multiple queries when I try to run multiple queries getting some errors
Same problem
thanks
No problem! Thanks for watching!
tttthaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
Thanks for watching it!
Can you help me with something, please.
What is that I could help you with?
@@TechVideoStack
I did all of my connections. Everything looks like normal, but does not show tables in mysql in code database etc.
@@TechVideoStack
Is there a place where I can throw my screenshot? and the error code
You can do that on my facebook page! Look for techvideostack and send me the screenshot
Did not work for me, was a waste of time
Try using older version of the extension!
Are you sleeping?
I woke up 5 hours ago 🥱
when i click add new connection it's showing blank tab
X2
Try reinstalling, not work.
Seems like there is an issue, with the recent extension update, by the creator. I see many are complaining about it. Tried to install it in a separate computer, but I get blank page, when creating a new connection. I believe, the creator will fix the issue, in the upcoming days ... If not, there is nothing I can do on that, as I am not the creator ... you could try to check for another extension that will work! I am sorry for the issue and not being able to help!
when i click add new connection it's showing blank tab
Try reinstalling the extension .. if it doesn't work, try reinstalling both: Visual Studio Code and the extension! Let me know if it worked!
Seems like there is an issue, with the recent extension update, by the creator. I see many are complaining about it. Tried to install it in a separate computer, but I get blank page, when creating a new connection. I believe, the creator will fix the issue, in the upcoming days ... If not, there is nothing I can do on that, as I am not the creator ... you could try to check for another extension that will work! I am sorry for the issue and not being able to help!
Same problem here!
@@TechVideoStack I use mysql. I installed this Extension:
SQLTools MYSQL/MariaDB . By search Extensions in Marketplace give this Extension identifer: mtxr.sqltools-driver-mysql.
@@batikuzey3327 and it works properly for you, right?