mysql

self.add('CREATE USER `{}`@`%` IDENTIFIED BY %s; '
.format(self.repl_user), (self.repl_password,))
self.add('GRANT SUPER, SELECT, INSERT, REPLICATION SLAVE, RELOAD'
', LOCK TABLES, GRANT OPTION, REPLICATION CLIENT'
', RELOAD, DROP, CREATE '
'ON *.* TO `{}`@`%`; '
.format(self.repl_user))
self.add('FLUSH PRIVILEGES;')

------------------------------------
self.add('GRANT USAGE ON *.* TO `{}`@`%` WITH MAX_USER_CONNECTIONS 3;'.format(self.mysql_monitor_user))
原文地址:https://www.cnblogs.com/mhc-fly/p/6955572.html