vscode-database | Extension for Visual Studio Code
kandi X-RAY | vscode-database Summary
kandi X-RAY | vscode-database Summary
Extension for Visual Studio Code
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of vscode-database
vscode-database Key Features
vscode-database Examples and Code Snippets
Community Discussions
Trending Discussions on vscode-database
QUESTION
I know this should be more focused but I lost whole day on this and I cant figure it out.
I am trying to connect to remote MySQL database using any of available VS Code extensions.
I tried to use SQLTools with MySQL/MariaDB plugin, ApexSQL Database Power Tools for VS Code, vscode-database.
I have read all documentations and searched here and else-ware for examples. All I am finding is connecting to local-host databases.
I just wont list all combinations I tried, because I feel I tried them all. Using all possible log in methods.
Biggest problem I have come across using few methods is when i enter remote server address and username. That username always transfers to: username@'93-138-183-84.adsl.net.t-com.hr'
where 93-138-183-84.adsl.net.t-com.hr' of coarse is my current IP address.
And I get errors like:
...ANSWER
Answered 2020-Oct-22 at 17:11So finally after whole day:
using macOS:
I already had SSH keys added to system so I just need to open tunneling, its easy just one line, explanation is here: How to connect to a MySQL database using an SSH Tunnel
ssh -p 722 -N -L 3306:localhost:3306 user@servername
- use your ports and C-panel logins.
Next in VS code (tested with SQLTools with MySQL/MariaDB plugin):
use 127.0.0.1
as server address and enter your DB credentials.
And that is it.
Now you have autocomplete SQL methods, SQL litter and autocomplete all tables and fields from remote DB in VS-Code.
QUESTION
I use Visual Code (1.13.1) on a Mac (10.12.5). I have Color Picker (0.4.1), gitlens (4.1.3) and vscode-database (1.2.0) installed extensions.
Why I press tab to move away from some code that I have already intellisense completed, it changes the entire code block to some odd html/xml formatting...:
My cursor (you can't see it in the screen shot, is immediately after company_id
- and when I press TAB to move to inline with the =
in the line above it, it changes to this:
Has anyone got any clues as to what I need to turn off for this behaviour to cease?
Thanks in advance!
...ANSWER
Answered 2017-Jun-20 at 09:57go to:
File -> Preferences -> Keyboard shortcuts
find emmet.expandAbbreviation first thing that uses tab and change or delete that shortcut
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install vscode-database
Pick Extensions: Install Extension
Find vscode-database
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page