MySQL as the Source

mysql database

By default, when UGO connects to the mysql database, the user needs to be granted permission to access the mysql database.

Create a user.

CREATE USER <user> IDENTIFIEDBY passwd;

GRANT SELECT ON mysql.* TO <user>;

DDL Object Count Check

The system checks whether a user has the permission to access at least one schema where DDL statements need to be evaluated.

Ensure that at least one schema object where DDL statements need to be evaluated can be accessed, or the evaluation task cannot be created. Note: MySQL database objects are not checked.

Process

Permission to view all tables in information_schema.

Run the following statement:

GRANT PROCESS ON *.* TO <user>;

Object collection

Permission to collect objects

Run the following statements:

GRANT SELECT ON <schema_name>.* TO <user>;

GRANT SHOW VIEW ON <schema_name>.* TO <user>;

GRANT TRIGGER ON <schema_name>.* TO <user>;

Stored procedure and function

In MySQL 8.0.20 and later versions, if there are stored procedures and functions in the source database, grant the user SHOW_ROUTINE permission.

Run the following statement:

GRANT SHOW_ROUTINE ON *.* TO <user>;