Skip to main content

MySQL

Connecting to MySQL

Create MySQL User​

Create Omni user
CREATE USER omni IDENTIFIED WITH mysql_native_password BY 'some_password_here';

Grant SELECT​

Grant SELECT
GRANT SELECT ON database_name.* TO 'omni'@'%';

Create the connection in Omni​

Screenshot

  • Name: <CONNECTION_NAME>
  • Dialect: MySQL
  • Host: <YOUR_ACCOUNT>
  • Port: 3306
  • Database: <YOUR_DATABASE>
  • Default Schema <YOUR_SCHEMA>
  • User: omni (if you created a user above)
  • Password: <YOUR_PASSWORD>