{"id":400,"date":"2021-05-06T23:28:03","date_gmt":"2021-05-06T15:28:03","guid":{"rendered":"https:\/\/22pig.com\/?p=400"},"modified":"2021-05-06T23:28:03","modified_gmt":"2021-05-06T15:28:03","slug":"mysql%ef%bc%88mariadb%ef%bc%89%e6%96%b0%e5%bb%ba%e7%94%a8%e6%88%b7%e5%8f%8a%e7%94%a8%e6%88%b7%e6%8e%88%e6%9d%83%e7%ae%a1%e7%90%86","status":"publish","type":"post","link":"http:\/\/22pig.com\/?p=400","title":{"rendered":"mysql\uff08mariadb\uff09\u65b0\u5efa\u7528\u6237\u53ca\u7528\u6237\u6388\u6743\u7ba1\u7406"},"content":{"rendered":"

mysql\uff08mariadb\uff09\u65b0\u5efa\u7528\u6237\u53ca\u7528\u6237\u6388\u6743\u7ba1\u7406<\/p>\n

create user newuser@localhost identified by ‘123456’<\/span>;<\/p>\n

\u67e5\u770b\u7528\u6237\u6743\u9650<\/p>\n

MariaDB [(none)]> show grants for<\/span> my@localhost;\n+--------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n| Grants for<\/span> my@localhost                                                                                            |\n+--------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n| GRANT ALL<\/span> PRIVILEGES ON<\/span> *.* TO<\/span> 'my<\/span>'@'localhost<\/span>' IDENTIFIED BY PASSWORD '*6<\/span>BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' |\n+--------------------------------------------------------------------------------------------------------------------+<\/span><\/span>\n1<\/span> row in<\/span> set (0.00<\/span> sec)\n\nMariaDB [(none)]> \n<\/code><\/pre>\n
\u6307\u5b9a\u6388\u6743(\u5168\u90e8\u6743\u9650)<\/p>\n
 grant<\/span> insert<\/span>,update<\/span>,delete<\/span>,select<\/span> on<\/span> *.* to<\/span> mytest@localhost;<\/span><\/code><\/pre>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
mysql\uff08mariadb\uff09\u65b0\u5efa\u7528\u6237\u53ca\u7528\u6237\u6388\u6743\u7ba1\u7406 create user newuser@localhost identified by ‘123456’; \u67e5\u770b\u7528\u6237\u6743\u9650 MariaDB [(none)]> show grants for my@localhost; +——————————————————————————————————————–+ | Grants for my@localhost | +——————————————————————————————————————–+ | GRANT ALL PRIVILEGES ON *.* TO ‘my’@’localhost’ IDENTIFIED BY PASSWORD ‘*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9’ | +——————————————————————————————————————–+ 1 row in set (0.00 sec) MariaDB [(none)]> \u6307\u5b9a\u6388\u6743(\u5168\u90e8\u6743\u9650) grant insert,update,delete,select on *.* to mytest@localhost;    <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-400","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=400"}],"version-history":[{"count":0,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/400\/revisions"}],"wp:attachment":[{"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=400"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}