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