Datastudio does not connect with Mysql restricted user

Asked

Viewed 146 times

0

I created a new Mysql user with restricted permissions for only one VIEW. (GRANT ALL ON database.view TO'user@'localhost')

When I try to connect with this user in Datastudio I get denied access message. However, using the same user in any other tool like Sequelpro for example, I can connect in a good.

The question is: What permissions does Datastudio need to allow connection.

If I give a grant all on . it works. But that’s what I don’t want to do, because I need to restrict the user to just one VIEW.

mysql google-cloud

1 answer

-1

Solved !

The restricted user needed to be usuario'@'% and not usuario'@'localhost.

Browser other questions tagged mysql google-cloud

You are not signed in. Login or sign up in order to post.