天天看点

mysql privileges

admin:

GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY PASSWORD '*5D66E19896629DE1239D062FDED3ED770F84D153' WITH GRANT OPTION MAX_USER_CONNECTIONS 1999 

dbbak:

GRANT SELECT, DELETE, RELOAD, FILE, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'dbbak'@'localhost' IDENTIFIED BY PASSWORD '*AEF4F9289BDDAC7519231FB6304115B7C6485AEF' WITH MAX_USER_CONNECTIONS 1999

dbsrt:

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, SHOW VIEW ON *.* TO 'dbsrt'@'localhost' IDENTIFIED BY PASSWORD '*5D66E19896629DE1239D062FDED3ED770F84D153' WITH MAX_USER_CONNECTIONS 1999 

zhulei110810:

GRANT SELECT, INSERT, UPDATE, CREATE TEMPORARY TABLES ON *.* TO 'zhulei110810'@'%' IDENTIFIED BY PASSWORD '*5F8EF0E2406FDCA1F8F6307200BC728F77D78576' WITH MAX_USER_CONNECTIONS 999