AnswerBun.com

Setting password for MySQL root user in CLoudSQL with private IP address

How to change the password for MySQL root user in GCP CloudSQL DB instance with private IP address . I am able to change the password using the below command from Cloud Shell with Public IP

    gcloud sql users set-password root  --instance=testdb --prompt-for-password

but it does not work for instances with Private IP address .

I can use the GCP Console to change the password but the root user is not listed under Users TAB

Console--> CloudSQL--> DB Instance --> Users

Other option seems installing gcloud on a VM in the same network as CloudSQL and change it using below command

gcloud sql users set-password root  --instance=testdb --prompt-for-password

Any other suggestion to change password for root user in a MySQL private DB instance . I need to change the password as initially the DB was created skipping the password.

Also is it more secure to use --host=% option while changing the password with gcloud command.

gcloud sql users set-password root --host=% --instance=testdb  --prompt-for-password

Server Fault Asked by Zama Ques on December 26, 2020

1 Answers

One Answer

I tested the command and I was not able to update the password not even in a Cloud SQL instance with public IP (and I did a lot of tests for example running the command from a VM). I raised a Public Issue Tracker mentioning this issue. I recommend you add a +1 in order that the engineering team this issue into consideration and this one be resolved :)

Answered by Andie Vanille on December 26, 2020

Add your own answers!

Related Questions

Docker compose errror when mounting the volumes

2  Asked on December 20, 2021 by zetacu

   

Domain Admin can not take ownership of files

2  Asked on December 20, 2021 by myles-rowley

   

NGINX – Only proxy a specific URL

1  Asked on December 20, 2021 by egyas

     

Assign a dedicated NIC to a KVM guest only

0  Asked on December 18, 2021 by nicapicella

   

Tasks Scheduler Windows High Availability

1  Asked on December 18, 2021 by julien-merice

       

MDB2, Pear, Mysql error

1  Asked on December 18, 2021 by kyle-hudson

   

Creating a Static IP With wlan0

4  Asked on December 18, 2021 by nmagerko

   

nginx mime types and gzip

2  Asked on December 18, 2021 by tompave

   

Golang – Nginx proxy pass issue

1  Asked on December 18, 2021 by arunkolhapur

   

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved.