0

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

 
0

My old projects

Posted by EvolutionCrazy on Jun 11, 2009 in Uncategorized

As I’m going to close down “evcz.altervista.org”, will archive here something from my past…

phpipblocker (last version 0.99j)
phpipblocker archive

php2dns (last version 0.91beta)
php2dns archive

Tags: ,

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