Google cloud SQL – adding a new user with GRANT privilege

Posted by EvolutionCrazy on Nov 2, 2013 in Uncategorized |

Google cloud sql does not support the

GRANT ALL PRIVILEGES on * . *

command…

in order to create a new user with (almost) all the privileges access the cloud sql console and run these commands:

CREATE USER 'newuser'@'%' IDENTIFIED BY 'newpassword';
GRANT ALL ON `%`.* TO 'newuser'@'%' IDENTIFIED BY 'newpassword';

Those will create a user named “newuser” with password “newpassword” able to connect from every host and able to create new users while granting them access to other databases

Copyright © 2018 evcz.tk All rights reserved. Theme by Laptop Geek.