{"id":459,"date":"2021-10-28T14:42:46","date_gmt":"2021-10-28T05:42:46","guid":{"rendered":"https:\/\/www.despina.work\/wordpress\/?page_id=459"},"modified":"2021-10-28T21:38:56","modified_gmt":"2021-10-28T12:38:56","slug":"sql","status":"publish","type":"page","link":"https:\/\/www.despina.work\/wordpress\/?page_id=459","title":{"rendered":"SQL"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>Hyper-V\u3092\u4f7f\u7528<\/li><li>\u30a4\u30e1\u30fc\u30b8\u306fubuntu-20.04.3-live-server-amd64\u4f7f\u7528<\/li><li>\u30e1\u30e2\u30ea\u306f1GB\u7a0b\u5ea6\u30ca\u30a4\u30c8SQL\u30b5\u30fc\u30d3\u30b9\u304c\u3046\u307e\u304f\u7acb\u3061\u4e0a\u304c\u3089\u306a\u304b\u3063\u305f\u308a\u3059\u308b\u3002<\/li><li>php\u30a2\u30d7\u30ea\u306e\u547c\u3073\u51fa\u3057\u7528\u3002\uff11\u3064\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u7279\u6a29\u30e6\u30fc\u30b6\u3092\uff11\u5bfe\uff11\u3067\u4f5c\u308b\u3002phpMyAdmin\u3067\u7ba1\u7406\u7528\u306b\u305d\u308c\u305e\u308c\u306b\u7279\u6a29\u4ed8\u4e0e\u3002\u305d\u308c\u3060\u3051\u3002<\/li><li>show databeses , drop databes , dro puser<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE XXdb DEFAULT CHARACTER SET utf8;<br>CREATE USER XXXuser IDENTIFIED BY 'XXXXXpass';<br>GRANT ALL ON XXdb.* TO XXXuser;<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hyper-V\u3092\u4f7f\u7528 \u30a4\u30e1\u30fc\u30b8\u306fubuntu-20.04.3-live-server-amd64\u4f7f\u7528 \u30e1\u30e2\u30ea\u306f1GB\u7a0b\u5ea6\u30ca\u30a4\u30c8SQL\u30b5\u30fc\u30d3\u30b9\u304c\u3046\u307e\u304f\u7acb\u3061\u4e0a\u304c\u3089\u306a\u304b\u3063\u305f\u308a\u3059\u308b\u3002 php\u30a2\u30d7\u30ea\u306e\u547c\u3073\u51fa\u3057\u7528\u3002\uff11\u3064\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-459","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=459"}],"version-history":[{"count":4,"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/459\/revisions"}],"predecessor-version":[{"id":510,"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=\/wp\/v2\/pages\/459\/revisions\/510"}],"wp:attachment":[{"href":"https:\/\/www.despina.work\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}