Last active
December 26, 2020 04:06
-
-
Save sgs00/cfaeb4bdcd365252a31450860c9a6b70 to your computer and use it in GitHub Desktop.
Google Cloud SQL Proxy
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
## 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