#MySQL #GCP #Terraform #CloudDatabases #InfrastructureAsCode #phpMyAdmin
*Deploy MySQL on Google Cloud with Terraform – Cloud SQL Edition*
In this video, we walk through deploying MySQL on Google Cloud using Cloud SQL, a fully managed relational database service. You’ll learn how to build a secure, private MySQL environment from the ground up using Terraform.
*What You’ll Learn*
- How to provision a private Cloud SQL MySQL instance with Terraform
- Best practices for VPC design, private networking, and firewall rules
- Connecting with phpMyAdmin to explore your data via a web UI
- Optional: Load a sample MySQL dataset like Pagila or Sakila for testing
- Delaying Cloud SQL creation to avoid VPC peering race conditions
*Resources Deployed*
- Custom VPC and subnet
- Private VPC Service Controls for Cloud SQL
- MySQL 8.0 Cloud SQL instance (private IP only)
- Ubuntu VM with phpMyAdmin for browser-based SQL access
- Secure password generation using Terraform
---
GitHub: https://github.com/mamonaco1973/gcp-mysql
README: https://github.com/mamonaco1973/gcp-mysql/blob/main/README.md
---
00:00 Introduction
01:55 GCP Diagram
03:49 Prerequisites
04:27 Build the Code
06:04 Build Results
09:52 Demo