Describe the bug
When executing mysql-schema.sql, an error occurs that causes the script to fail.
After debugging, I found that the root cause is that the roles and permissions tables do not have primary keys defined.

The error message is as follows:

Error Code: 3750. Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set. Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.

Please consider adding primary keys to the role and permission tables to resolve this issue.

ps: i will send a pr to fix this