ContextQMD
Back to Materialize

Allow Materialize Ips

doc/user/layouts/shortcodes/mysql-direct/ingesting-data/allow-materialize-ips.html

123921 B
Original Source
  1. In the SQL Shell, or your preferred SQL client connected to Materialize, use the CREATE SECRET command to securely store the password for the materialize MySQL user you created earlier: mzsql CREATE SECRET mysqlpass AS ''; For AWS IAM authentication, you must create a connection to AWS. See the CREATE CONNECTION command for details. 1. Use the CREATE CONNECTION command to create a connection object with access and authentication details for Materialize to use: mzsql CREATE CONNECTION mysql\_connection TO MYSQL ( HOST , PORT 3306, USER 'materialize', PASSWORD SECRET mysqlpass, SSL MODE REQUIRED ); - Replace `` with your MySQL endpoint. AWS IAM authentication is also available, see the CREATE CONNECTION command for details.