How to Use VS Code to Run SQL on a Database

[@DatabaseStar]

Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?

[@pirithoven_tech]

This video is insanelly underrated... Amazing...🙏

[@DatabaseStar]

I'm glad you think so!

[@kelsihill5131]

Hi at your time stamp 4:46, the screen where it says "Use password", mine does not say that. It says "password mode" and gives the options 'SQLTools driver credentials' ,'Ask on connect', 'Use empty password', and 'Save as plaintext in settings'. When I attempted to try each of these it gave me an error once I clicked save connection. I tried uninstalling and reinstalling all of my extensions and even tried downloading different versions of vsc but it still shows this. Any idea how to fix this??

[@DatabaseStar]

Oh that's strange, perhaps the authors have updated the extension. Is your password correct? If it is, I would suggest contacting the author or developer of the extensions.

[@Eeswar-hh5gz]

same

[@ZyNx50]

In 4:23, when I tried the connection I have an error that says: Client option 'pooling.maxIdleTime' does not support value 'NaN'. can someone help me with this.

[@DatabaseStar]

I think you'll need to enter a value somewhere on the connection screen. There are some other comments on this error I believe.

[@priyajaiswal486]

​@@DatabaseStar Can you please make a video on this error how to resolve this

[@unruly_ronin]

Hey man, your videos are super helpful. I just wanna ask, what do I do at 5:55 when I try to Test Connection it tells me ("Client option 'pooling.maxIdleTime' does not support value 'NaN'. ") When I put a value of 30 like you said, it says ("The server has gone away") Yours came so quickly so I'm stumped

[@DatabaseStar]

Thanks! I’m not sure why you’re getting that error about the server going away. The NaN issue is mentioned in a few other comments and I think adding that value like you have would resolve it. Unsure about the other error thought.

[@unruly_ronin]

@@DatabaseStar That's ok. Thanks for the reply. I'm sure I'll find a way.

[@harshitkhandelwal9983]

@@unruly_ronin hey did you find the way ??

[@nedu6118]

@@harshitkhandelwal9983 did you find a way? I need help too

[@koushikkv745]

I got the same error , change authentication protocol to default then it will be successful.

[@LimitlessEI]

im trying to learn sql on my own through youtube. at 5:20 where you link the database you put new_app what does this mean and what do i need to do to create my own. thank you for the great video

[@DatabaseStar]

Good question! The "new_app" is the name of an existing "database" that has been created on a MySQL server. If you have already installed MySQL on your computer, you probably won't have any databases yet. So, you'll have to open another tool such as MySQL Workbench and create a new database. This is what I did - I created a new database called "new_app" in MySQL Workbench, and then specified it here. This needed to be done in another application (not VS Code) because this Database field is mandatory - unfortunately we can't just connect here and then create a database after we connect.

[@CodeIsForBros]

Bro I'm gonna kiss you on the lips. You just saved me hours of work

[@DatabaseStar]

Hahah thanks!

[@sengoku2662]

Ayo

[@Dragonforge-Studios]

Tf u gay

[@hassanadedoyin8062]

No no no this should only be done to your wife! NO EVEN YOUR MATURED DAUGHTER

[@joaquimmenezes7396]

Ayoooo 😂😂

[@gregjerry4110]

Has anyone told you that you have a nice teaching voice, because you do

[@DatabaseStar]

Thanks!

[@sadmage8]

6:54 I'm trying this on mac os and I'm stumped by what to put in the Database. SSMS isn't available for Mac so how do I create a database on my local machine for visual studio to access?

[@DatabaseStar]

Ah good question. If you want to run SQL Server on your Mac, you could use a tool called Docker. That’s what I use and I have a video about it on my channel. If you don’t necessarily need to use SQL Server, you could install either MySQL or Postgres, both of which work directly on Mac.

[@sadmage8]

@@DatabaseStar Thanks for the response. I'll look into setting up docker. As for mysql and postgresql, I'm not sure about them. I'm not too educated about sql actually. But I've joined a course to learn it and I wanted to set it up on my MacBook beforehand. The instructor is just going to use SSMS so I doubt he will be able to help me

[@memeti5835]

ı thing you are god :D , I was constantly getting errors, no one explains it as well as you 👍

[@DatabaseStar]

Thanks a lot! I’m glad you liked the video

[@jancesenek668]

Hi, thanks for the great easy-to-follow-content! I only have one minor problem that bothers me, around 10:20 whenever I run any query, I don't see the green box even when it's successful, it does show errors, however a feedback on successful queries is essential for me. Any idea how to fix this? Thanks in advance

[@DatabaseStar]

That's interesting. Is the query successful? I'm not sure why the box would not be appearing. Perhaps there's a setting that shows or hides this panel. Or perhaps it's a known issue in a certain version of the extension.

[@jancesenek668]

@@DatabaseStar The query is successful. I checked the settings and wasn't able to find it anywhere.

[@mohammed96410]

it says ECONNREFUSED using postgreSQL

[@DatabaseStar]

I'm not sure why that would be the case. Did it work in another SQL editor (such as pgAdmin)?

[@spondoolie6450]

If you have been banging your head against your desk trying to get MySQL to work then you've found the correct video and the answer is at 4:50

[@DatabaseStar]

Thanks!

[@attilatasnadi50]

Hey, I successfully added the database but when i try to connect i got the next error message: Request connection/GetChildrenForTreeItemRequest failed with message: Handshake inactivity timeout What should i do?

[@DatabaseStar]

Hmm I’ve never heard of that message. Could you check the GitHub repo of this plugin to see if others have the same issue? Or some Googling if you have t some so already.

[@lucasliu6622]

Me2

[@dDevAhmed]

Hello Attila, please were you able to fix the problem?

[@lestibournesastalsi5466]

Try this kzbin.info/www/bejne/ravHdKOAjpuMasU If it does not work, you may have to use other sql extensons. I use Jun Han's extension instead.

[@gastonmarengo6790]

Whenever I'm in the SQLTools Settings and I click on "Test Connection" I get a red error message saying "The server has gone away" I read that I can change the timeout time in the PHP document for SQL but I'm unsure of doing this, anyone knows another solution?

[@DatabaseStar]

There's a setting on the connection screen about the timeout which you can increase to a higher number, and this may solve the issue. If not, then it may be a MySQL issue.

[@JoshuaJameson-e2b]

Hey mate - thanks for the video, very helpful! When you say you've just created a new database using MySQL workbench - any chance you could give some more detail on that please? Thanks again!

[@DatabaseStar]

No prolem! Sure, I mean that I used MySQL Workbench to create a database. I opened MySQL Workbench and connected to MySQL running on my computer. I then created a new database which is an area that can hold database objects such as tables.

[@hohobells752]

i also had an error in 6:00 when i did test connection. it says, "client option 'prooling.maxIdleTime' does not support value 'NaN'." what does it mean? :

[@DatabaseStar]

It means you need to enter a value into that field, and we can't leave it empty. A few other people had this issue in the comments.

[@studionimba]

I keep getting this error message when setting up a new connection: sqltools error error : connect econnrefused :: 1:33060

[@DatabaseStar]

Hmm is the database running? I assume this is MySQL as it uses port 3306.

[@harshitasharma4034]

@Database Star i installed all there extensions from market place but in add new connection second one that is SQL Tool Post GRE is not visible.

[@DatabaseStar]

Oh that's strange, perhaps there's an issue with the extension with Postgres not appearing.

[@Tewahedo16]

It was good but i just stop on 5:34 min😢😢😢 i don't understand what you said.

[@DatabaseStar]

At this point, I'm entering the password to use for the root account to log in to MySQL. This is the same user and password you would use if you're accessing the database using MySQL Workbench or some other editor.

[@Tewahedo16]

@@DatabaseStar Thank you for your response.

[@thresh-]

Do i need to download MySQL before doing all these steps or is it usable with just the plugin? (Like an internal VSC sql server)

[@DatabaseStar]

Yes, you'll need to have access to a database, such as MySQL. You can download and install MySQL on your computer. There is no internal database included with the plugin.

[@tobyhamilton2153]

In the video you mentioned you'd be creating a video on how to use the orcale database VS Code extension, I have seen some videos where you use it with docker (I don't know what docker is), but have you created a similair style video to this were in the beginning you just run through how to connect properly, without brining any other technologies like docker.

[@DatabaseStar]

Hey, that’s a good suggestion. I don’t have a video on using vs code with oracle on a regular database like Oracle Express. But I can create a video like that. The only difference would be the connection details.

[@CaribouDataScience]

In SSMS I enter LAPTOP-QFUJTI9Q\SQLEXPRESS for the Server name. In SQL Tools where do I enter the server name?

[@DatabaseStar]

I'm not sure. Could you try connect without it? Perhaps it's in the server name field.

[@chakookietete]

I got 'failed to connect to localhost:1433 - could not connect (sequence)' . What should I do?

[@DatabaseStar]

Hmm I’m not sure. Is the database running? What does Google say?

[@bilalillahi6347]

Have you resolved the problem? I am facing the same problem

[@TokenRR]

Good day. How to remove the "highlight" like you have in the video 10:02

[@TokenRR]

I use postgresql and this glow never goes out

[@TokenRR]

I solved this problem, I just had to remove the check mark in the extension settings

[@DatabaseStar]

Oh good to know. Thanks for sharing your solution.

[@justinehercthehuman]

I have a question. When I did this, I already made schemas and databases in the past. When I access them (such as Select/Desc), it returns with "No Data" even when the databases already have data. Is there a fix for this? Or do I have to create all databases from the start again?

[@DatabaseStar]

That's interesting. Do you see them if you access them using another editor such as SQL Developer? Do you see the tables in the object browser on the left panel?

[@ar_sa112]

Have i understood that correctly, do i need to install the MySQL server on my laptop first, in order to create a MySQL Connection in VS Code Studio?

[@DatabaseStar]

Yes that’s right!

[@thefamousdjx]

Companies actually allow people to connect to databases using random extensions from the internet?

[@DatabaseStar]

Yeah, some do. Some would limit it to only one specific tool such as SSMS, but others have a more relaxed policy or a recommendation, especially if the extension an be assessed by the company’s security team. Good point about trusting extensions though!

[@PoloAssasin2]

6:52 I use mssql and I log in with windows authentication. How do I find the password for connecting it on vs code?

[@DatabaseStar]

It should be the same password you use when connecting with other editors such as SSMS. The password depends on your database setup - e.g. the one you set when you installed SQL Server Express, or for a different user.

[@nyadokuamponsah04]

Hey, I have installed the extension sqltools but I cant see it in the side bar. what might be wrong?

[@DatabaseStar]

Maybe there is a setting in VS Code that needs to be adjusted? Or maybe you need to restart VS Code?

[@LowQualitty]

Helped me run specific queries, thanks!

[@DatabaseStar]

Glad it helped!

[@Jacknorrington]

Hey, I love everything you showed me and although i had like 30 different errors i was able to work them all out except for one, where you talk about things at 11:15 , it keeps saying that it cannot find the table that I had just created, do I have to refresh it or what? I went into mysql and typed in the exact same things and it worked and went back into sqltools and was editting stuff there, but is there a delay or a refresh that has to happen? Thank you

[@DatabaseStar]

Thanks! I'm not sure, perhaps there is a refresh that needs to happen. The object explorer that shows the tables may need to be refreshed, but if you write a query that refers to the table it should work. Did you happen to use square brackets or single quotes around your table name?

[@Jacknorrington]

@@DatabaseStar hey, I figured it out, I needed to route my usenode thing in settings to my node application on my computer and it auto updates now!! Thanks for everything

[@許凱翔-t4k]

Hi, i faced to some problem when i add a new connection. I fill in same information and click "TEST CONNECTION" button. it shows error "Client option 'pooling.maxIdleTime' does not support value 'NaN'." Do I create a database before i add new connection?

[@DatabaseStar]

For this error I think you need to enter a value into the max idle time field rather than leave it empty. And yes I think you need a database first.

[@moloko_127]

10:03 I dont have this button for running it :( Anyone knows the problem ?

[@DatabaseStar]

h that's odd. Are you connected to the database?

[@usoppgostoso]

Well, my issue is I'm using a CA Certificate to authenticate to my Azure MySQL server, and this extensions appears to not have an option to select the path to it.

[@DatabaseStar]

Oh that's a shame it's not available

[@timbui5556]

Hi Ben, as always, thank you for your teaching! On a different topic, can I run Postgresql on Visual Studio (not Visual Studio Code)? Would you please send some instruction? Thank you!!!

[@DatabaseStar]

Thanks Tim! I'm not sure how, but I am guessing you can. There may be an extension for Visual Studio, just like the one in VS Code, that can be used to access a database. I'll create a video on this in the future.

[@4q1lx_x]

Great Video!!! but i have an issue/error... it say "Request connection/GetChildrenForTreeItemRequest failed with message: Client option 'pooling.maxIdleTime' does not support value 'NaN'." Can you help me?

[@DatabaseStar]

Thanks! I think others have left comments with this error. If that doesn't work then perhaps Google can help.

[@nearbyyou5644]

Hey, I had this same error Can you please tell me how you fix this

[@biddragon]

really like your video, waiting for the Oracle SQL video

[@DatabaseStar]

Glad you like it! The Oracle one is coming soon.

[@bigdataon-premorcloud7866]

how to allow each connection to show all db that the role is allowed to connect? For example, suppose I have a role named developer and allow to connect to these databases. postgres, myAppdb, myDB3, etc. how to show all these database after connecting to the connection? Pgadmin4 will show all the DBs that developer can connect to.

[@DatabaseStar]

Good question. I'm not sure how to do that in this extension unfortunately.

[@theoriarinne9814]

Very helpful and easy to understand, thank you so much.

[@DatabaseStar]

Glad it was helpful!

[@ZedTheThrid]

Solid video, though how would you connect this and python together?

[@DatabaseStar]

I imagine you would set up Python as normal, and then access it from within VS Code?

[@omondif9]

Hi Ben, thanks for the video, but i am getting a this error: 'Error opening connection Unknown database 'mysql_database'' . Not sure how to go about it

[@DatabaseStar]

Hmm. Do you have a database with that name on your server? You can check which database are available in another IDE such as MySQL Workbench

[@javabrain8480]

At 5:56 I got an error "pooling.maxIdleTime" doesn't support nan

[@DatabaseStar]

I think this was found and addressed by other comments and I think the solution is to put a number into that field.

[@GJSoftware]

Great video, thanks for creating it!

[@DatabaseStar]

Glad you liked it!

[@CookedEli]

No matter what driver i try, it gives me "error" when testing the connection. All default parameters, basically all that is changed are the names and the password. What am I supposed to do, considering that everyone has no issues by the looks of it.

[@DatabaseStar]

Which database vendor are you using (Oracle, SQL Server, MySQL, Postgres, or something else)? Are you able to use the same connection details in another editor?

[@CookedEli]

​@@DatabaseStar managed to get it working, had to reinstall postgres... edit: now my next question is how to stop the ''making a new tab for each SQL query'' part edit2: nvm figured that one as well.. have a nice day

[@petersobhy6987]

Please can you tell me how i can connect to multiple databases in the same time using sql server driver Thanks in advance.

[@DatabaseStar]

I think you can set up multiple connections in the connections panel?

[@petersobhy6987]

@@DatabaseStar would you please tell me how?

[@seeramaheswari4658]

I installed my sql but couldn't get sakila and sys database in my work bench

[@DatabaseStar]

The sys database should be already there by default. Sakila is a database I believe you have to download and install separately.

[@coolsocks4452]

Hi, what if I want to import the csv file directly into vscode instead of going through pgAdmin4, is that possible?

[@DatabaseStar]

Good question, I'm not sure if VS Code allows you to do this!

[@coolsocks4452]

@@DatabaseStar yeah you right, we have to import first on pgAdmin, thanks for answer my question sir. God bless you

[@ShlokShah16]

5:57 Mine doesn't connect, shows error 😢

[@DatabaseStar]

Oh what error are you getting?

[@ShlokShah16]

@@DatabaseStar It shows Client option 'pooling.maxldleTime' does not support value 'NaN'.

[@AmerickiZivot]

Hi, I’m working on the Coursera Capstone project and I’m trying to figure out how to utilize .csv files. Is that possible?

[@DatabaseStar]

Hey, you can import CSV files into your database as a table. I don't know if you can do this in the VS Code extension, but you can do it in most SQL Editors.

[@RohitKumar-ip1qp]

What to enter in Database name in VsCode? I have installed mysql server on my Mac.

[@DatabaseStar]

You can probably entere localhost

[@RohitKumar-ip1qp]

@@DatabaseStar same issue

[@rohitashwapratapsingh142]

On testing the connection, I get this error- Client option 'pooling.maxIdleTime' does not support value 'NaN'.

[@rohitashwapratapsingh142]

help

[@DatabaseStar]

Hey, I think there are some other comments with the same question. I think you can enter a value in one of the fields on the connection and it should work.

[@seifhossam7465]

add a connection Timeout = 15

[@martinbaculak6769]

You sir, are the Jesus of Database.

[@DatabaseStar]

Thanks a lot!

[@Unknown-j7d6k]

Will the work also for mac computers?

[@DatabaseStar]

Yes, it should. I use VS Code all the time on a Mac.

[@mohamednabe7203]

hi,installing databases in visual studio codes met this problem, how can you help me please...

[@mohamednabe7203]

this error: Request connection/GetChildrenForTreeItemRequest failed with message: Client option 'pooling.maxIdleTime' does not support value 'NaN'.

[@DatabaseStar]

Hi Mohamed, I'm not sure what this error means. I would suggest Googling it, if you haven't done so already. Or, set a value for Max Idle Time when you create the conneciton.

[@khalilbazgour8017]

@@mohamednabe7203 Hi, I got the same error, did you manage to solve this problem?

[@josephrajasehar9761]

@@mohamednabe7203 I got the same error too

[@sarathsanthosh9688]

Failed to connect localhost:1433 -could not connect (sequence)

[@chavindualwis4730]

same here!

[@DatabaseStar]

Hmm I would suggest checking your username and password, or trying to connect using a different IDE to see if it's a problem with VSCode. Otherwise a Google search may give a solution.

[@olavomoreira7960]

@@DatabaseStar I got the same error and cant fix it. Any suggestion?

[@ycharzyyy939]

Error opening connection Client option 'pooling.maxIdleTime' does not support value 'NaN'. why this error?

[@DatabaseStar]

I think you may need to put a value in one of the fields on the screen. I think other commenters had the same issue.

[@nabilchahbani8734]

What about PostgreSQL databases that use SSH?

[@DatabaseStar]

Is there an option to specify that when connecting?

[@angkhoanguyen7566]

Hi, I have a problem in here. When I tried to create SQL server connect, I couldn't connect with "Login failed to user "testdb". Can someone help me fix this out? Tks

[@DatabaseStar]

Is there a user called test db? Or is that the database name?

[@angkhoanguyen7566]

@@DatabaseStar no, thats just database name. Btw, I figure out to fix this.

[@angkhoanguyen7566]

@@DatabaseStar I just have subcribed your channel, very useful and great. Thank you

[@tugrularslan542]

SQLServer connection is not working on me. With SSMS yes, not with vsc

[@DatabaseStar]

What issue are you having with it?

[@999nico]

Does MS SQL Extension enough to use SQL with Visual Studio Code? Thanks

[@DatabaseStar]

Yes, it has enough of the basic functionality to let you write queries and see results. For more advanced stuff, you may want to use another IDE such as SSMS.

[@joycefred6913]

Hi Thanks for the video. When I try to test connection I keep getting this error "connect ECONNREFUSED ::1:3306" I don't know how to move past this. any help on how to fix this?

[@DatabaseStar]

I’m not sure how to solve that one unfortunately

[@jiaprincess4512]

sir mySQL is not showing me that exact icone which is appearing in your window on connection time, kindly help to access those icons so i can be able to connect it with VS code. I really have no time for wait, I've only one day, bcz my project's viva is almost on my head

[@DatabaseStar]

Which icon are you missing? Is it the cylinder icon on the left panel? Or something else?

[@jiaprincess4512]

@@DatabaseStar Sir my VS code is showing the error "Found that duplicate Database Client extensions are installed, please uninstall the duplicate!" Kindly guide me that how can I know that which is this duplicate extension???

[@黃望潮]

Hi~I have a problem for my sql server 2008 using vscode to connect database ,I have no idea which one extension that I can use?any one can help ? Thank you guys assistance.

[@DatabaseStar]

Hi, you should be able to use this extension mentioned in the video to connect to SQL Server.

[@黃望潮]

@@DatabaseStar Thanks for you answer,but I'd tried to use SQL Server given connect String as like "Data Source=,;Initial Catalog=;User ID=;Password=", step by step...then I just could see the database cluster shown ,when I use sql code "select * top 1000 from ....", it appeared : This is likely caused by the extension that contributes mssql.scriptSelect.... So I thought that Sql2008 is the reason why ?and what's you opinion?

[@seeramaheswari4658]

how to create database in visual studio code to run sql how many times i try still get error in localhost server name i think make a video on how to create database and how to use it in vs code

[@DatabaseStar]

I have a video coming out soon on exactly how to do that (for MySQL databases, as that's where it's a required field). You can use the Terminal or Command Prompt to create a database if you don't already have one.

[@walidslimani]

i have sql plus in my pc , so how do it in VS code

[@DatabaseStar]

You can use this video to connect to your database using VS Code. SQL Plus is a command-line tool for Oracle.

[@zeehutt7876]

Are Port Number and Process ID the same thing?

[@DatabaseStar]

I believe they are different. Port number is like the gate that is used to communicate between two things. A process ID is a unique number for a process that runs on the computer.

[@cobbyrichie8092]

Hi boss, thanks very much for this wonderful tutorial, my question is, can I run this offline without internet connection??

[@DatabaseStar]

Glad you like it! Yes, assuming you have a database installed on your own computer. You can connect to that and it should work.

[@josephizz4877]

is their a way to import an excel file using vscode?

[@DatabaseStar]

I'm not sure - I'll have to take a look!

[@mustafa._.9371]

My problem is that I don't see any of the buttons up top like "run on active connections". Can anyone help please?

[@DatabaseStar]

Oh that’s strange. Have you connected to a database? If so which database vendor is it?

[@harshkumarsrivastava4100]

Error opening connection Login failed for user 'sys' .......how to resolve this?

[@DatabaseStar]

Is the password correct? Are you trying to connect to an Oracle database (I think SYS is part of Oracle)? If it's Oracle then you'll need to use a different extension. I've got another video on how to use Oracle with VSCode on my channel.

[@mitchelleleeuw2266]

I love the video. Is there by any chance a way i can connect to IBM informix???

[@DatabaseStar]

Thanks! I’m not sure as I don’t have any experience with IBM Informix.

[@leggynaut8760]

Not sure why but i got an ECONNREFUSED error when i tried running the MySQL connection

[@DatabaseStar]

That’s strange. I’m not sure why either. Hopefully something on Google can help.

[@Shubham_848Vlog]

how to dump data from csv to compact edition data base file.

[@DatabaseStar]

You can use an IDE to import the CSV into your database, and the process is different for each IDE. In Visual Studio Code, I'm not sure how it's done. I'm not sure if the extension has this feature.

[@ishmaelmanne8811]

How do I solve the 'the server has gone away' error

[@DatabaseStar]

I’m not sure. I did a quick search and it seems to be a timeout issue or something like that. Perhaps restarting your computer or VS code could fix it.

[@BainapalliPavitro]

Hi, thanks for this video but I got "read ECONNRESET" error could you help me out on this problem....

[@DatabaseStar]

Hmm I’m not sure what that error means unfortunately

[@mdashraful2089]

I keep getting this error "Failed to connect to localhost:1433 - Could not connect (sequence)" Plz Help !!

[@DatabaseStar]

Oh I’m not sure how to solve that unfortunately. Other commenters may have had the same issue though.

[@aswinipenneru3513]

Even though installed step by step I didn't get any connection assistant

[@DatabaseStar]

Oh that’s strange, I thought it would come up correctly

[@maxbilo6191]

Amazing tuto!

[@DatabaseStar]

Thanks!

[@mahasallam9481]

I'm having a problem adding a new contact, can you help me please?

[@DatabaseStar]

Sure, what do you mean by a new contact?

[@My_state_of_m9d]

You truly did a good job, but when following your steps, I stuck in this error: Failed to connect to localhost:1433 - Could not connect (sequence). Tell me how can I solve it

[@DatabaseStar]

Thanks! I'm not sure how to solve that one, perhaps you'll have to Google it.

[@jishua9]

The error i keep getting is just "The server has gone away" and not matter what i set the time out value to, it errors straight away

[@DatabaseStar]

That's strange. I haven't seen that before. It might be something that Google/StackOverflow could help with (unless you've already tried that)

[@levels7]

I encountered the same problem too...pls help

[@cyborgmetropolis7652]

"Add new connection" opens up a blank window for me. Trying it out on a linux vm.

[@DatabaseStar]

Oh that’s not good. I would suggest contacting the plugin team for this. Not sure why it would show a blank screen.

[@ImJordanHubbard-qg9qt]

Jsut to let you know that Oracle is now supported

[@DatabaseStar]

Oh that’s good to know!

[@airaharune8108]

like new_app....how do i set my database

[@DatabaseStar]

It depends on your vendor, but you could use the USE command.

[@Ayobenji]

Hi, Please i have been looking for a video tutorial of how I can link my HTML, CSS and JS to SQL file for web app

[@DatabaseStar]

I think you'll need some kind of server-side programming language involved to connect HTML and JS to a database. You could use something like Node.js, or PHP, or .NET, or something else.

[@athak23]

what if it doesnt connect?

[@DatabaseStar]

You can try in another editor or resolve the connection issue, which depends on your database vendor and the error message.

[@Sagatpred]

What username and password should I be using?

[@DatabaseStar]

It’s whatever username and password is set up on your database already. This depends on what database you’re using, eg it could be root for MySQL or sa for SQL Server or something else.

[@adityatapase1170]

sir am unable to install sql in vscoder please guide us

[@DatabaseStar]

What issue are you having installing VS Code?

[@AonyjsViolmlar05]

awesome tools but not sure how to use this with ssh.

[@DatabaseStar]

Good point, I'm not sure how to use it either. Do you mean ssh within VS Code, or separately?

[@AonyjsViolmlar05]

@@DatabaseStar yes ssh within vscode to access mysql.

[@04ansarimaazan65]

self signed certificate in certificate chain how to fix this

[@DatabaseStar]

What is the issue you're having?

[@FuskiInfluencer]

My test connection is not matching 😢

[@DatabaseStar]

What do you mean it is not matching?

[@shaquibalikhan6151]

how to know username ? i am writing root and it is not accepting .

[@DatabaseStar]

Root should be the default admin username for MySQL. Which database are you using?

[@shaquibalikhan6151]

@@DatabaseStar using MYSQL

[@josephrajasehar9761]

I got a query error message on the right side

[@DatabaseStar]

Ah what error message did you get?

[@cipriandanila1773]

Nice tutorial! 🥰

[@DatabaseStar]

Thanks!

[@SanyamSinghSolanki]

hii, how to create a database? and username?

[@DatabaseStar]

Depending on which database vendor you are using, you should be able to connect to the database using the command line or a different SQL editor and create a database. The username will also depend on which vendor you're using.

[@CaribouDataScience]

Thanks that was easy.

[@DatabaseStar]

Glad you found it easy!

[@ritikraj2629]

Request connection/GetChildrenForTreeItemRequest failed with message: Unknown database 'myshop' i got this error please help me😭😭😭

[@DatabaseStar]

Does the database "myshop" exist on your database server?

[@nanayaaadomaadoku-amponsah672]

heyyyy, thanks for such a great video.

[@DatabaseStar]

You’re welcome!

[@L.TChannel]

Hey, thank you for the video, it helps a lot. but i have recived "Login failed for user 'sa'", any reason for that? (P.S: i entered the corrected password)

[@DatabaseStar]

Hmm it could be the database is not running. Are you able to connect using another tool such as SSMS? It could also be the server name is incorrect

[@L.TChannel]

@@DatabaseStar yes, I can connect to the database with SSMS, I am not sure what is going on…