Hi,
The users from the master are replicated to the replica. So, you should be able to connect to the replica if you provide the right information. These are the steps I followed:
1. Add a user on master instance for all hosts. (CREATE USER 'abcdefg'@'%' IDENTIFIED BY 'abcdef';)
2. Flush privileges.
3. Connect to the replica instance.
On Tue, Jan 26, 2016 at 9:31 AM, Graphics Geeks <graphicsguru600@gmail.com> wrote:
Hello Lee,--Thanks for helping me.I'm a bit confused about this, since it doesn't seem from the interface that I can even set any users for a read replica instance.And setting the root password is not allowed for the replica - it says it has to be the same as the master?
Kind regards
On Tuesday, January 26, 2016 at 6:00:57 PM UTC+1, Lee S. wrote:You need to set the user passwords for the replica separately. You can do this from the cloud console under 'access control > users'. The system tables don't get replicated so the users have to be created on each replica separately.
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/98c7fec1-e5cb-443f-8122-c2a53a072caa%40googlegroups.com.
Vishnu Fafat
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAPVxmMCqeQvXj96PoCGBcz1ad4SzXOwduJNa-cmhM2KwzhPi5A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment