cweijan / vscode-database-client Goto Github PK
View Code? Open in Web Editor NEWDatabase Client For Visual Studio Code
Home Page: https://database-client.com
License: MIT License
Database Client For Visual Studio Code
Home Page: https://database-client.com
License: MIT License
"Generate Mock Data" is such a awesome feature for me, so I want bring it to my python code and try to generate db data with your way, so I wonder if Is this possiable to transfer "Generate Mock Data" feature into Python library?
Hi,
Not sure whether I missed something out but the extension doesn't seem to work I get
command 'mysql.connection.add' not found upon clicking + .
Do I need to configure or install something first before using this plugin. Thanks.
Hi,
I got the following error when I tried to connect to localhost mysql:
Connection error! ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Can you please advise how to solve this? Thanks.
I work with multiple hosts and databases at the same time and this MySQL client helps a lot!
However, there is a high risk of code running for the wrong host (even with the little host-IP in the status-bar).
The following changes would be a great asset to me:
Thanks for reading!
BTW: Keep the work up! This is by far the best client vor VSCode! Star nr. 100 for you!
it will be easier for user to find a table if table list is sorted.
thx for your great tools.
Sorry I can't speak english.
Run MYSQL Query(F9) is Dead
mysql password is null
v2.2.4 is work
windows10
xampp
Confirmed with php 5.6, 7.2
连接的时候出现"element with id **** is already registered"是怎么回事啊
Hi I don't now if this is a bug but when I do a query to show a data in table, does not move horizontally in in this windows resultset
希望支持USING
关键字,这个关键字在连表时非常有用,在SELECT
,UPDATE
,DELETE
中都经常使用
SELECT column_list
FROM table_1
JOIN table_2 USING (column_name);
Hello! I'm really enjoying this plugin! It's very useful!
I'd like to report a small issue. When you click the (+) button to insert a new row in a table within the transactions menu, all NOT NULL
columns are showed as "required", but this isn't true under the following conditions:
AUTO_INCREMENT
appliedDEFAULT
valueThe Table view should feature a dark mode to best fit with VSCode dark mode themes,
我一直在用感觉挺好的
Every time I'm open vscode, the output window is always opened, I think this is not expected behavior, or at least don't automatically show this. Thank's...
Can you add support for the UNSIGNED
keyword? This keyword is very commonly used
In issue (#4 (comment)) it was noted that the right click option was added, but this is not visible in 1.9.1.
Originally posted by @cweijan in #4 (comment)
Performance
vscode-mysql-client
1.7.22
Linux x64 5.6.2-050602-generic
1.44.2
/home/don/cweijan.vscode-mysql-client-unresponsive.cpuprofile.txt
cweijan.vscode-mysql-client-unresponsive.cpuprofile.txt
Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load
I do like this plug-in with its beautiful visual interface but there's a frustrating bug when I run queries, the Query board always shows me "EXECUTE FAIL:
Message :
ER_EMPTY_QUERY: Query was empty"
although my query is not empty at all.
I hope this bug be repaired soon.
Thanks for your effort.
when I selected id (bigint(20)) from table, then it display like this:
1292434711813128200
1292434718599512000
1292434961730732000
1292434968399675400
1292434968399675400
The last two digits are carried forward.
Here's the real story:
+---------------------+
| id |
+---------------------+
| 1292434711813128194 |
| 1292434718599512065 |
| 1292434961730732034 |
| 1292434968399675393 |
| 1292434968399675394 |
+---------------------+
5 rows in set (0.00 sec)
I'm already loving your extension bro. Awesome work. I gave you 5 star on Marketplace and stared on github already. Keep up the good work.
Just a suggestion only if you got enough time to support this. I found this feature in some other mysql client extension that you can execute a mysql query from any file selected text. The selected text query must end with a semi colon so the parser can pick query easily. And then execute it on the current connected session.
I couldn't find this feature in your extension, if it's already there let me know and I'll be happy to use it.
Performance
vscode-mysql-client2
2.1.8
Windows_NT x64 10.0.17763
1.45.1
C:\Users\29220\cweijan.vscode-mysql-client2-unresponsive.cpuprofile.txt
Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load
When I try to call any store procedure, the output display only freezes on the loading page. I am not sure this feature is not supported yet or it's a bug, or there is something wrong in my vscode's settings. Additionally, if I click a procedure in the left control bar, the system will show "Error: ER_SP_DOES_NOT_EXIST: PROCEDURE undefined does not exist".
Error output VSCode:
Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
at Handshake.module.exports.Sequence._packetToError (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:3310:14)
at Handshake.module.exports.Handshake.ErrorPacket (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:59292:18)
at Protocol.module.exports.Protocol._parsePacket (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:52087:23)
at Parser._parsePacket (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:52698:10)
at Parser.write (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:52308:10)
at Protocol.module.exports.Protocol.write (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:51834:16)
at Socket.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:5016:28)
at Socket.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:5454:10)
at Socket.emit (events.js:203:13)
at addChunk (_stream_readable.js:295:12)
at readableAddChunk (_stream_readable.js:276:11)
at Socket.Readable.push (_stream_readable.js:210:10)
at TCP.onStreamRead (internal/stream_base_commons.js:166:17)
--------------------
at Protocol.module.exports.Protocol._enqueue (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:51940:48)
at Protocol.handshake (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:51847:23)
at Connection.connect (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:5044:18)
at Function.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:298:51)
at Generator.next (<anonymous>)
at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:214:71
at new Promise (<anonymous>)
at module.exports.__awaiter (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:210:12)
at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:259:49
at new Promise (<anonymous>)
at Function.getConnection (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:259:16)
at MysqlConnectService.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104581:57)
at Generator.next (<anonymous>)
at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104567:71
at new Promise (<anonymous>)
at module.exports.__awaiter (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104563:12)
at MysqlConnectService.connect (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104575:16)
at MysqlConnectService.<anonymous> (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104633:40)
at Generator.next (<anonymous>)
at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104600:71
at new Promise (<anonymous>)
at module.exports.__awaiter (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104596:12)
at Object.receiveListener (c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:104629:60)
at c:\Users\Francisco\.vscode\extensions\cweijan.vscode-mysql-client2-2.3.8\out\extension.js:5880:35
at e.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:242)
at K.$onMessage (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:786:33)
at e._doInvokeHandler (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:804:1013)
at e._invokeHandler (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:804:705)
at e._receiveRequest (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:803:344)
at e._receiveOneMessage (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:802:156)
at c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:800:416
at e.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:242)
at v.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:239:274)
at c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:975:649
at e.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:242)
at v.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:239:274)
at t.PersistentProtocol._receiveMessage (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:243:629)
at c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:240:824
at e.fire (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:242)
at p.acceptChunk (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:236:737)
at c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:236:89
at Socket.t (c:\Users\Francisco\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:245:185)
at Socket.emit (events.js:203:13)
at addChunk (_stream_readable.js:295:12)
at readableAddChunk (_stream_readable.js:276:11)
at Socket.Readable.push (_stream_readable.js:210:10)
at Pipe.onStreamRead (internal/stream_base_commons.js:166:17)
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
-----------------------------------------------------------------------------------------
Related:
https://stackoverflow.com/questions/44946270/er-not-supported-auth-mode-mysql-server
mysqljs/mysql#1507
Add an ability to change database context via right click option instead of requiring a new query
Hi, I maintain VS Code's Webview API
Our telemetry suggests that your extension uses webviews and may be loading resources in these webviews using hardcoded vscode-resource:
URIs. These URIs have some important limitations and don't work properly when VS Code is run in a browser. We are also making changes in the desktop version of VS Code that may cause these URIs to not work properly in future versions of VS Code.
While we are making our best effort to continue support existing webview extensions that use vscode-resource:
URIs on desktop versions of VS Code, we will not able to fully support all uses cases.
To ensure that your extension continues to work in as many environments as possible—including on web and remotely—please:
Switch to use the Webview.asWebviewUri
function for loading resources.
Switch to use the Webview.cspSource
property in content security policies.
These APIs shipped around 2 years ago so they should be available in all modern versions of VS Code. You can find additional information about the issue here: microsoft/vscode#97962
Let me know if you have any questions about this change
Can u add support for the delimiter
keyword to support modifying stored procs? The other MySql plugin supports it (https://marketplace.visualstudio.com/items?itemName=poreklo.vscode-mysql)
Performance
vscode-mysql-client
1.9.8
Linux x64 5.3.0-61-generic
1.46.0
/home/hemant/cweijan.vscode-mysql-client-unresponsive.cpuprofile.txt
Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load
Hello!
First of all, I would like to say this is the best extension I've found so far for MySQL.
The only feature I miss is the same as the MySQL workbench, where you can limit the row count, not having to specify the LIMIT XX in every query.
Thank you :)
The MySQL I connect to is behind a VPN. This plugin always tries to connect to MySQL even if I don't want to. If I open vscode to edit some file without being connected to the VPN, the plugin won't be able to connect to the database and it would give this error
2020-08-12 09:59:04 : Error: connect ETIMEDOUT
at Connection.module.exports.Connection._handleConnectTimeout (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:5524:13)
at Object.onceWrapper (events.js:291:20)
at Socket.emit (events.js:203:13)
at Socket._onTimeout (net.js:434:8)
at listOnTimeout (internal/timers.js:531:17)
at processTimers (internal/timers.js:475:7)
--------------------
at Protocol.module.exports.Protocol._enqueue (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:52105:48)
at Protocol.handshake (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:52012:23)
at Connection.connect (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:5231:18)
at Function.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:300:51)
at Generator.next (<anonymous>)
at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:216:71
at new Promise (<anonymous>)
at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:212:12)
at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:261:49
at new Promise (<anonymous>)
at Function.getConnection (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:261:16)
at ConnectionNode.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:9925:74)
at Generator.next (<anonymous>)
at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:9885:71
at new Promise (<anonymous>)
at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:9881:12)
at ConnectionNode.getChildren (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:9922:16)
at DbTreeDataProvider.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1887:43)
at Generator.next (<anonymous>)
at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1861:71
at new Promise (<anonymous>)
at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1857:12)
at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1886:79
at Array.forEach (<anonymous>)
at DbTreeDataProvider.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1886:51)
at Generator.next (<anonymous>)
at fulfilled (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.6\out\extension.js:1858:58)
at processTicksAndRejections (internal/process/task_queues.js:85:5)
connect ETIMEDOUT
-----------------------------------------------------------------------------------------
The extension should only try to connect o a db when I click on it and ask it to connect.
Hi, I maintain VS Code's Webview API
Our telemetry suggests that your extension uses webviews and may be loading resources in these webviews using hardcoded vscode-resource:
URIs. These URIs have some important limitations and don't work properly when VS Code is run in a browser. We are also making changes in the desktop version of VS Code that may cause these URIs to not work properly in future versions of VS Code.
While we are making our best effort to continue support existing webview extensions that use vscode-resource:
URIs on desktop versions of VS Code, we will not able to fully support all uses cases.
To ensure that your extension continues to work in as many environments as possible—including on web and remotely—please:
Switch to use the Webview.asWebviewUri
function for loading resources.
Switch to use the Webview.cspSource
property in content security policies.
These APIs shipped around 2 years ago so they should be available in all modern versions of VS Code. You can find additional information about the issue here: microsoft/vscode#97962
Let me know if you have any questions about this change
I disabled this plugin autoconnect feature as per your recommendation here. I see the error below, not sure if they're related.
2020-08-17 15:31:15 : Error: read ECONNRESET
at TCP.onStreamRead (internal/stream_base_commons.js:183:27)
--------------------
at Protocol._enqueue (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:52105:48)
at Protocol.handshake (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:52012:23)
at Connection.connect (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:5231:18)
at Function.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:300:51)
at Generator.next (<anonymous>)
at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:216:71
at new Promise (<anonymous>)
at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:212:12)
at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:261:49
at new Promise (<anonymous>)
at Function.getConnection (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:261:16)
at ConnectionNode.<anonymous> (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:9925:74)
at Generator.next (<anonymous>)
at c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:9885:71
at new Promise (<anonymous>)
at module.exports.__awaiter (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:9881:12)
at ConnectionNode.getChildren (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:9922:16)
at DbTreeDataProvider.getChildren (c:\Users\user-pc\.vscode\extensions\cweijan.vscode-mysql-client2-2.4.8\out\extension.js:1909:24)
at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:620:416
at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:52:136
at new Promise (<anonymous>)
at Object.t.asPromise (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:52:108)
at m.fetchChildrenNodes (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:620:384)
at m.getChildren (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:617:739)
at t.ExtHostTreeViews.$getChildren (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:614:695)
at m._doInvokeHandler (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:819:926)
at m._invokeHandler (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:819:618)
at m._receiveRequest (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:818:252)
at m._receiveOneMessage (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:817:6)
at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:815:161
at l.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:222)
at v.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:239:494)
at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:1007:179
at l.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:222)
at v.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:239:494)
at t.PersistentProtocol._receiveMessage (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:244:17)
at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:241:67
at l.fire (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:46:222)
at p.acceptChunk (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:236:949)
at c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:236:301
at Socket.t (c:\Users\user-pc\AppData\Local\Programs\Microsoft VS Code\resources\app\out\vs\workbench\services\extensions\node\extensionHostProcess.js:245:572)
at Socket.emit (events.js:203:13)
at addChunk (_stream_readable.js:295:12)
at readableAddChunk (_stream_readable.js:276:11)
at Socket.Readable.push (_stream_readable.js:210:10)
at Pipe.onStreamRead (internal/stream_base_commons.js:166:17)
read ECONNRESET
-----------------------------------------------------------------------------------------
When I click the settings button, the output is:
Error: ENOENT: no such file or directory, scandir 'C:\Program Files (x86)\MySQL'
Definately the best MySQL editor for VSCode. Any chance you support the varbinary field type in the near future?
Currently the addon only shows a number (probably the value of the first byte) in a varbinary field. Editing the field also doesn't work.
EXECUTE FAIL:
INSERT INTO test_table(user_id,meeting_id,text,modified_on,created_on) VALUES(1,1,测试 文本,1588133313,1588133313)
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 '文本,1588133313,1588133313)' at line 1
it seams that single quotes has bean omitted with text
type.
extension version: 1.9.4
Bug
vscode-mysql-client
1.7.32
Windows_NT x64 10.0.18363
1.44.2
Bug
vscode-mysql-client2
2.4.2
Windows_NT x64 6.3.9600
1.47.3
I think it's pretty clear, currently the SSH tunneling only supports password authentication.
Could you add support for pubkey authentication?
And let me use this FR to thank you for your work on this extension!
Performance
vscode-mysql-client
1.7.20
Windows_NT x64 10.0.18363
1.45.0-insider
C:\Users\druide\cweijan.vscode-mysql-client-unresponsive.cpuprofile.txt
Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load
OS INFO : Windos 10:Windows_NT x64 10.0.19041, vscode : 1.47.3, vscode-mysql :v2.4.6
172.18.56.185
When I enter host as 172.18.56.185, I find that the IP address prompted is not correct. The specific information is as follows:
Connection error! ER_HOST_NOT_PRIVILEGED: Host '172.18.48.1' is not allowed to connect to this MySQL server
When I enter host as 10.0.10.27, I find that the IP address prompted is not correct. The specific information is as follows:
Connection error! ER_ACCESS_DENIED_ERROR: Access denied for user 'root'@'10.222.0.1' (using password: YES)
REFERENCES
和CHECK
关键字虽然已经能够高亮,但是还是不能补全,希望作者能够添加?
Performance
vscode-mysql-manager
1.6.37
Windows_NT x64 10.0.18363
1.45.1
C:\Users\dramm\cweijan.vscode-mysql-manager-unresponsive.cpuprofile.txt
Find more details here: https://github.com/microsoft/vscode/wiki/Explain-extension-causes-high-cpu-load
For now, we only two choices for database field on "Connect to MySQL server" Panel: one db or empty( all db), but for some scenarios, we got so many dbs here and only want some of them to show on connect items, can we input one more db names on "Connect to MySQL server" Panel? or, provide a setting item on the UI to display or hidden the specified dbs?
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.