Hello, Im testing the creation of a read only user. I have created the user ‘r-db01’ with select permissions only. In previous version of Mysql 5.5 if I connected as the ready only user, and I did “show databases;” it would only allow me to see the granted database and information_schema.
I am testing this read only user on the new 5.7 install and when I do a “show databases” as the read only user I created, I see all the databases. Did something change? Is there a new way of achieving this with 5.7?
thank you in advance.