Unable to create or change a table without a primary key

[xiangyanw]

Describe the bug
Failed to create tables when initialing MySQL DB using mysql-schema.sql in AWS RDS Multi-AZ DB Cluster. Error message as below:

Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set.

This is because sql_require_primary_key is set to true in MySQL cluster. But roles and permissions table have no primary key.

Expected behavior
Be able to init table successfully.

Actually behavior
Failed to create table roles and permissions.

How to Reproduce
Steps to reproduce the behavior:

1. Create an AWS RDS MySQL Cluster;
2. Download mysql-schema.sql;
3. Init database by mysql-schema.sql;
4. See errors

Desktop (please complete the following information):

• MySQL version: 8.0.35
• Deployment option: Multi-AZ DB Cluster
• Nacos version: 2.3.2

Additional context
Add any other context about the problem here.