DataStudio does not connect with restricted user Mysql

0

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

When I try to connect to this user in DataStudio I get access denied. However, using the same user in any other tool like SequelPro for example, I can connect to a good one.

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

If I give a GRANT ALL ON . there it works. But that's what I do not want to do because I need to restrict the user to just one VIEW.

    
asked by anonymous 16.02.2018 / 18:45

1 answer

-1

Solved!

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

    
19.02.2018 / 03:12