C.3.30. MySQL 8.0+, User Roles and Smartscale

C.3.30. MySQL 8.0+, User Roles and Smartscale
Prev	^Up	C.3. Error/Cause/Solution	Next

C.3.30. MySQL 8.0+, User Roles and Smartscale

Last Updated: 2021-11-29

Condition or Error

When configuring a connector to use SmartScale, you receive an error indicating users do not ave the required repl_client privilege despite the privilege being granted via a Role (New in MySQL 8.0)

Causes

Known issue occuring in all versions that support MySQL 8.0. This is due to tpm not aware of Roles, and therefore unable to determine that privileges have been grated in this way.

Rectifications

Providing you are certain the correct privileges have been granted, you can simply instruct tpm to ignore this particulare validate check by adding the following option to your configuration:
```
skip-validation-check=MySQLConnectorPermissionsCheck
```

Prev	Up	Next
C.3.29. Event application failed: seqno=20725782 fragno=0 message=java.sql.SQLDataException: Data too long for column 'eventid' at row 1	^Level	C.3.31. element 'mysql_readonly' not found in path

Continuent Documentation

C.3.30. MySQL 8.0+, User Roles and Smartscale