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

0
3 comments

Hello,

please add this to the very end of your connection URL right after database name:

?useUnicode=true

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?

0
Avatar
Permanently deleted user

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.

0
Avatar
Permanently deleted user

When I update Mysql Server to version 8.0.21. The error is gone. It happens on version 8.0.0 . Thanks for support

0

Please sign in to leave a comment.