Select the project that contains the Cloud SQL instance for which you want
to set the database flags.
Open the instance and click Edit.
Go to the Flags section.
Click Add a database flag.
Choose the following flags from the drop-down menu, and set their values:
Flag
Value
net_read_timeout
3600
net_write_timeout
3600
wait_timeout
86400
Click Save to save your changes.
Create a Datastream user
To create a Datastream user, enter the following MySQL commands:
CREATE USER 'datastream'@'%' IDENTIFIED BY 'YOUR_PASSWORD';
GRANT REPLICATION SLAVE, SELECT, REPLICATION CLIENT ON *.* TO 'datastream'@'%';
FLUSH PRIVILEGES;
What's next
Learn more about how Datastream works with MySQL sources.