Web lists-archives.com

In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?




Hi there,

In MySQL 8, how can you figure out if an entry in the mysql.user table is a role or a user?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.