Bug #116831 Issue with Database Access via MySQL Workbench

• Submitted: 29 Nov 18:41
• Modified: 2 Dec 10:53
• Reporter: Ion Cebotari
• Status: Not a Bug
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[29 Nov 18:41] Ion Cebotari

Description:
I encountered an issue while working with MySQL Workbench. I needed to test a database connection using the "Test Connection" function to retrieve a password for a Python script. Due to frequent attempts (I couldn't remember the password), access to the database is now blocked.

When attempting to connect to any database, an error message appears, indicating an issue with MySQL Workbench.

How to repeat:

Open MySQL Workbench.
Select any saved database connection.
Click "Test Connection" multiple times, entering incorrect passwords.
After several failed attempts, observe the error message and inability to connect to any database.

[2 Dec 10:53] MySQL Verification Team

Hi Mr. Cebotari,

Thank you for your bug report.

However, this is not a bug.

Both users, hosts from which they connect and all passwords are hidden.

This is a necessity in order to maintain a total security of the access to the MySQL server.

You have to create a new user and assign it a password, directly on the server. Our Reference Manual, that can be found on https://dev.mysql.com contains all the commands necessary.

However, as explained in the same Manual, you have to have user with privileges who can do that.

Not a bug.