How do you write the statement to view permissions in MySQL?

To view the permissions of a MySQL user, you can use the following statement:

SHOW GRANTS FOR 'username'@'host';

In this case, ‘username’ refers to the username whose permissions are to be viewed, and ‘host’ is the hostname to which the user is connected. If you want to view the permissions of all users, you can set both ‘username’ and ‘host’ to ‘%’.

Please note that only users with viewing permissions can execute this statement.