Tables not shown under the Database in a MysqlConnection

Hi,

I have created a MySQL connection correctly in Collibra DQ. When I navigate to Explorer and expand my connection I can see the databases, but inside them, I cannot see the tables. I have given my user all grant permissions, but it still not working.

This is a picture of DQ without tables:

And in this image, there is at least one table.

Did I miss something?

Thank you!

anasalas

Posted 5 years ago · Edited 1 year ago·Last reply 5 years ago

6 comments

anasalas

OP5 years ago · Edited

Any idea?? I can’t use my MySql database.

leonkim

·5 years ago · Edited

try adding “?useSSL=false” to the end of connection url, like:

jdbc:mysql://blah-blah-blah-blah.rds.amazonaws.com:3306?useSSL=false

leonkim

·5 years ago · Edited

try adding “?useSSL=false” to the end of connection url, like:

jdbc:mysql://blah-blah-blah-blah.rds.amazonaws.com:3306?useSSL=false

anasalas

OP5 years ago · Edited

leon.kim.collibra.com:

useSSL=false

No, the result is the same

anasalas

OP5 years ago · Edited

This is my connection.

leonkim

·5 years ago · Edited

can you show show the connections settings you used for mysql in the Connections page > edit the connection