Before ingesting MySQL metadata into Dawiso, prepare your account for authentication by creating a dedicated user and granting it the necessary permissions.
Dawiso Cloud currently supports the traditional authentification method using credentials.
Supported MySQL versions
- 8.0 and later
Connection prerequisites
- You have the global �PLACEHOLDER0� privilege or the �PLACEHOLDER1� privilege for the
mysqlsystem schema
Create a new user
First, create a new dedicated user using the following statement:
CREATE USER 'user_name'@'%' IDENTIFIED BY 'password';Replace the user_name and password with your values. Refer to the official MySQL documentation for more details.
Grant permissions to the user
The minimum required permissions you need to set for the user are:
GRANT SELECT, SHOW VIEW, EXECUTE ON *.* TO 'user_name'@'%';
FLUSH PRIVILEGES;Replace the user_name with the user created in the previous step.
Sample script
You can copy paste the following script and run it on your server.
CREATE USER 'DawisoIntegration'@'%' IDENTIFIED BY 'Password123';
GRANT SELECT, SHOW VIEW, EXECUTE ON *.* TO 'DawisoIntegration'@'%';
FLUSH PRIVILEGES;