Can not show tables in localhost mysql
Completed
Tables now showed in menu 'Database'. But when I query 'select * from book', it still shows the data. The error happens when i refresh database
Please sign in to leave a comment.
Hello,
please add this to the very end of your connection URL right after database name:
also you can try to remove|change value for 'characterEncoding' and 'characterSetResult' on Advanced tab of Data Source properties.
also please read this issue
so, connection is successful but you can get a data from database? what is collation for that database? can you create new one from DataGrip?
Sorry. I mean the tables are not shown in menu 'database'. The query create table is successful but no table is shown. I also connect by Mysql Workbench and it works.
When I update Mysql Server to version 8.0.21. The error is gone. It happens on version 8.0.0 . Thanks for support