Bug #111077 I click on the + under database connections and nothing happens
Submitted: 18 May 2023 16:00 Modified: 19 May 2023 3:58
Reporter: Sean O'Connor Email Updates:
Status: Analyzing Impact on me:
None 
Category:Shell VSCode Extension Severity:S1 (Critical)
Version: OS:Any
Assigned to: MySQL Verification Team CPU Architecture:Any

[18 May 2023 16:00] Sean O'Connor
Description:
I loaded it and when I hit the + on the database connections..  nothing happens..  It seems very self explanatory, hit the plus to create a connection..   But it does nothing.  

Version: 1.77.3 (user setup)
Commit: 704ed70d4fd1c6bd6342c436f1ede30d1cff4710
Date: 2023-04-12T09:16:02.548Z
Electron: 19.1.11
Chromium: 102.0.5005.196
Node.js: 16.14.2
V8: 10.2.154.26-electron.0
OS: Windows_NT x64 10.0.19044
Sandboxed: Yes

Error log:
12:17:51.800542 INFO: Starting MySQL Shell GUI web server...

12:17:51.801541 INFO: 	Checking web server certificate...

12:17:51.990659 INFO: 	Certificate is installed.

12:17:51.997691 ERROR: Log message could not be inserted into db. near "Connor": syntax error

Could it be because my name has an apostrophe in it and somehow that is preventing me from creating a database connection?

PLEASE SEE PREVIOUS BUG.  #110670  The developer seemed to just close it and not look at it again.

I don't think the developer even tried to reproduce my setup.  My last name has an apostrophe in it and somewhere you have SQL that is failing.  Can you please setup a username with apostrophe or go look at the part of code where the apostrophe is getting injected?  See the error above.

Thanks.

How to repeat:
Click on the + and have a username with an apostrophe.  See error around dynamic SQL being messed up.