​

Creating a service account user

​

1. Log in to MySQL

Log in to your MySQL server as a user with administrative privileges:

mysql -u root -p

Enter the password when prompted.

​

2. Create the service account user

CREATE USER 'service_account'@'localhost' IDENTIFIED BY 'secure_password';

• Replace service_account with your desired username.
• Replace secure_password with a strong password.

​

3. Grant privileges

Fabi.ai needs read access to the schemas you wish to query.

GRANT SELECT ON database_name.* TO 'service_account'@'localhost';

​

4. Apply changes

Run the following command to ensure the privileges are applied:

FLUSH PRIVILEGES;

​

Connecting MySQL to Fabi.ai

Once you’ve generated your service user credentials, follow the steps in Connecting to Your Data