{"id":1229,"date":"2023-12-27T11:54:02","date_gmt":"2023-12-27T03:54:02","guid":{"rendered":"http:\/\/learning.sino-vt.com:8988\/?p=1229"},"modified":"2023-12-27T11:54:02","modified_gmt":"2023-12-27T03:54:02","slug":"6-2%e7%89%88%e6%9c%ac%e6%95%b0%e6%8d%ae%e5%ba%93%e6%99%ae%e9%80%9a%e7%94%a8%e6%88%b7%e6%9d%83%e9%99%90","status":"publish","type":"post","link":"http:\/\/learning.sino-vt.com:8988\/index.php\/2023\/12\/27\/6-2%e7%89%88%e6%9c%ac%e6%95%b0%e6%8d%ae%e5%ba%93%e6%99%ae%e9%80%9a%e7%94%a8%e6%88%b7%e6%9d%83%e9%99%90\/","title":{"rendered":"6.2\u7248\u672c\u6570\u636e\u5e93\u666e\u901a\u7528\u6237\u6743\u9650"},"content":{"rendered":"

6.2\u5e73\u53f0\u6570\u636e\u5e93\u6743\u9650\u5982\u4e0b\uff1a<\/p>\n

\u7528\u6237\u540dauditsys(\u4ee5\u5b9e\u9645\u4e3a\u51c6)<\/p>\n

GRANT SELECT ON mysql.* TO ‘auditsys’@’%’;<\/p>\n

GRANT CREATE, DROP,SELECT,UPDATE,DELETE,ALTER,INSERT,LOCK TABLES ON \u5e93\u540d<\/strong>.* TO ‘auditsys’@’%’;<\/p>\n

\uff08\u4ee5\u4e0b\u547d\u4ee4\u53ea\u5305\u542b\u4e00\u90e8\u5206\u5e94\u7528\u7684\u6570\u636e\u5e93\uff0c\u5982\u679c\u6709\u5176\u4ed6\u5e94\u7528\uff0c\u9700\u8981\u589e\u52a0\u5bf9\u5e94\u5e93\u7684\u6743\u9650\uff0c\u6570\u636e\u5e93\u540d\u79f0\u4ee5\u5b9e\u9645\u4e3a\u51c6\u3002\uff09<\/p>\n

GRANT SELECT ON mysql.* TO ‘auditsys’@’%’;
\nGRANT CREATE, DROP,SELECT,UPDATE,DELETE,ALTER,INSERT,LOCK TABLES ON sinoueba.* TO ‘auditsys’@’%’;
\nGRANT CREATE, DROP,SELECT,UPDATE,DELETE,ALTER,INSERT,LOCK TABLES ON sinosdp.* TO ‘auditsys’@’%’;
\nGRANT CREATE, DROP,SELECT,UPDATE,DELETE,ALTER,INSERT,LOCK TABLES ON sinoits.* TO ‘auditsys’@’%’;
\nGRANT CREATE, DROP,SELECT,UPDATE,DELETE,ALTER,INSERT,LOCK TABLES ON sinoaudit.* TO ‘auditsys’@’%’;<\/p>\n

 <\/p>\n

LOCK TABLES \u589e\u52a0\u4e86\u8fd9\u4e2a\u6743\u9650\uff0c\u5df2\u53d1\u5e03\u65b0\u7248\u672c\u4f1a\u7528\u5230<\/p>\n

\u901a\u77e5\u65f6\u95f4\uff1a20231226<\/p>\n","protected":false},"excerpt":{"rendered":"

6.2\u5e73\u53f0\u6570\u636e\u5e93\u6743\u9650\u5982\u4e0b\uff1a \u7528\u6237\u540dauditsys(\u4ee5\u5b9e\u9645\u4e3a\u51c6) GRANT SELECT ON mysql. […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[21,30],"class_list":["post-1229","post","type-post","status-publish","format-standard","hentry","category-auditsys","tag-mysql","tag-sinoueba"],"_links":{"self":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/1229","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/comments?post=1229"}],"version-history":[{"count":1,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/1229\/revisions"}],"predecessor-version":[{"id":1230,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/1229\/revisions\/1230"}],"wp:attachment":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/media?parent=1229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/categories?post=1229"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/tags?post=1229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}