Pycharm not showing tables of database in schemas

created at 03-07-2021 views: 1

problem

after connecting to my remote MySQL database and refresh, my Pycharm still not showing the tables of the database. It just show structures like bellow:

if your Pycharm not showing tables of your remote MySQL database, you could check as follows and make corresponding changes:

solution: configure Database Tools

1、 right click and choose Database Tools 

2、 choose Manage Shown Schemas

3、now you come to this dialog, and you may see the name of your target database (which you want to show in the structure)

in this case, my database is named workflow:

Check it and refresh. 

now come back to the Schemas, you will see the database is already showing there:

Please log in to leave a comment.