You can find the password from VM management console System Log

1. Go to GCP VM2 console at https://console.cloud.google.com/logs/.
2. Chose your Instance and click on the three-dot menu → View logs

Get MySQL root password