Bug #110199 Cannot connect to database
Submitted: 24 Feb 2023 0:05 Modified: 27 Feb 2023 12:36
Reporter: Osvaldo Dias dos Santos Email Updates:
Status: Duplicate Impact on me:
None 
Category:Shell VSCode Extension Severity:S3 (Non-critical)
Version:1.8.0 OS:Linux (Pop!_OS 22.04 LTS)
Assigned to: CPU Architecture:x86 (HP 82A5)
Tags: certificate, failed connection

[24 Feb 2023 0:05] Osvaldo Dias dos Santos 
Description:
Hi,

On setup, the certificate creation was successful, but trying to connect to a database I got this notification message:

"Failed to Connect
Please check if you have the
MySQL Shell rootCA.crt certificate
installed on your local system."

The MySQL installation might not have a password for "root". When trying to access as "root", I do it as "sudo MySQL" and enter the "sudo" password.

I have another user for regular database operations, which has not all "root" privileges.

Thanks,
Osvaldo.

How to repeat:
- Install extension
- Follow the steps for configuration
- Click on any of the two first icons to establish a connection
[27 Feb 2023 12:36] MySQL Verification Team 
Hello,

Thank you for the bug report.
Imho this is duplicate of Bug #106843, please see Bug #106843 and follow the steps suggested by dev.

Regards,
Ashwini Patil