Grant a user permission to only view a MySQL view and nothing else

mysql view permissions database-permissions grant

GRANT SELECT ON database1.view1 TO 'someuser'@'somehost';

mysql view permissions database-permissions grant

Besides

GRANT SELECT ON <database_name>.<view_name>TO <user>@<host>

it's better to also do

GRANT SHOW VIEWON <database_name>.<view_name> TO <user>@<host>

so that a lot of SQL UI tool can get the view definition and work appropriately for the view.

mysql view permissions database-permissions grant

GRANT SELECT ON <database name>.<view name>TO <user>@<host> IDENTIFIED BY '<password>'

CodeHunter