Skip to content

Instantly share code, notes, and snippets.

@sgs00
Last active December 26, 2020 04:06
Show Gist options
  • Save sgs00/cfaeb4bdcd365252a31450860c9a6b70 to your computer and use it in GitHub Desktop.
Save sgs00/cfaeb4bdcd365252a31450860c9a6b70 to your computer and use it in GitHub Desktop.
Google Cloud SQL Proxy
## https://cloud.google.com/sql/docs/mysql/sql-proxy
## install Google cloudsql proxy
# wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 -O cloud_sql_proxy
# sudo mv cloud_sql_proxy /usr/local/bin/
# sudo chmod +x /usr/local/bin/cloud_sql_proxy
# sudo nano /etc/systemd/system/cloud-sql-proxy.service
# create sql user '[USER_NAME]'@'cloudsqlproxy~%'
# sudo systemctl daemon-reload
# sudo systemctl enable cloud-sql-proxy
# sudo systemctl start cloud-sql-proxy
# sudo systemctl status cloud-sql-proxy
## This is CentOS, on Debian network.target maybe different.
## [START] /etc/systemd/system/cloud-sql-proxy.service
[Install]
WantedBy=multi-user.target
[Unit]
Description=Google Cloud Compute Engine SQL Proxy
Requires=network.target
After=network.target
[Service]
Type=simple
WorkingDirectory=/usr/local/bin
# you may need -credential_file=[PATH_TO_KEY_FILE]
ExecStart=/usr/local/bin/cloud_sql_proxy -instances=PROJECT:REGION:SQL_INSTANCE=tcp:3306
Restart=always
StandardOutput=journal
User=root
## [END] /etc/systemd/system/cloud-sql-proxy.service
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment