Can't GRANT ALL PRIVILEGES to a new user

74 views
Skip to first unread message

eric angleton

unread,
Oct 29, 2013, 1:00:43 AM10/29/13
to google-cloud...@googlegroups.com
I'm invariably getting a 1045 error when attempting this on any user; is this something that should work right now?  Can anyone confirm that they are able to grant all privileges to a newly-created user in particular.  

Razvan Musaloiu-E.

unread,
Oct 29, 2013, 1:04:51 AM10/29/13
to google-cloud...@googlegroups.com
That's expected because the SUPER is not available anymore (announcement is in [1]). You can use "GRANT ALL ON `%`.*" instead.


-- Razvan ME


On Mon, Oct 28, 2013 at 10:00 PM, eric angleton <angl...@gmail.com> wrote:
I'm invariably getting a 1045 error when attempting this on any user; is this something that should work right now?  Can anyone confirm that they are able to grant all privileges to a newly-created user in particular.  

--
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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/85934a26-7a64-4843-a6bb-8bd3f3eb3c4b%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

eric angleton

unread,
Oct 29, 2013, 1:09:16 AM10/29/13
to google-cloud...@googlegroups.com
Gotcha, I completely missed this, thanks for the alternative.  


On Tuesday, October 29, 2013 1:04:51 AM UTC-4, Razvan Musaloiu-E. wrote:
That's expected because the SUPER is not available anymore (announcement is in [1]). You can use "GRANT ALL ON `%`.*" instead.


-- Razvan ME
On Mon, Oct 28, 2013 at 10:00 PM, eric angleton <angl...@gmail.com> wrote:
I'm invariably getting a 1045 error when attempting this on any user; is this something that should work right now?  Can anyone confirm that they are able to grant all privileges to a newly-created user in particular.  

--
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+unsub...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages