Describe the bug

When you add a MySQL resource, if an user has access to multiple database, the resource may NOT get the correct database tables EVEN I put in a specific database name.

When I am in Resources, and click on "Manage", it show the INCORRECT table names which was from the incorrect database. However, if I type SQL in the window below with correct table name, it can run correctly.

To reproduce

1. Create a MySQL resource using an user with access to multiple database, put in the name of one of the database and save
2. Go to 'Resources'
3. Click on 'Manage'
4. The table list on the left panel show table name of another database that the user has access to.
5. The bottom of the window will have popup saying "Execution Error" and "table not exist"

Expected behavior

It should get database tables from the correct database.

Screenshots

No response

Browser information

No response

Application version

No response

Additional Context

No response