MySQL Configuration

purpose in mysql, the objective is to create a user that can connect and perform select operations on any database/table without modification rights grant permissions mysql connection only privilege grant usage on to ’\[ username ]’@’%’; \ grant read access to all tables grant select on to ’\[ username ]’@’%’; \ apply privileges flush privileges ; testing permissions connect as \[username] and execute a select query use testdb ; select from test table ; if \[username] can retrieve the data without an error, the privileges are correctly granted