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
阅读更多
个人分类: mysql
上一篇MySQL的备份
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭