mysql privileges

来源:互联网 发布:淘宝靠谱的单反店铺 编辑:程序博客网 时间:2024/06/11 17:20
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
原创粉丝点击