show mysql users and permissions code example Example: mysql user permission database GRANT ALL PRIVILEGES ON `db_name`.* TO 'user'@'host'