-
Notifications
You must be signed in to change notification settings - Fork 0
1.3 Mysql_user Priviledge.md
couplewith edited this page Mar 29, 2017
·
1 revision
use mysql ;
delete from user;
INSERT INTO `user` VALUES ('localhost','root',password('dadmin'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N','N','',0.000000);
INSERT INTO `user` VALUES ('stage-mysql01','root',password('dadmin'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N','N','',0.000000);
INSERT INTO `user` VALUES ('127.0.0.1','root',password('dadmin'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N','N','',0.000000);
INSERT INTO `user` VALUES ('::1','root',password('dbadmin'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'','','N','N','',0.000000);
-- update user set host = 'stage-mysql01' where host = 'stage-mysql01';
-- update user set host = 'stage-mysql02' where host = 'stage-mysql01';
-- update user set host = 'stage-mysql03' where host = 'stage-mysql01';
flush privileges;
CREATE USER 'wsrep'@'%' IDENTIFIED BY 'wadmin';
CREATE USER 'root'@'%' IDENTIFIED BY 'dadmin';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
flush privileges;