{"id":617,"date":"2023-11-02T23:06:56","date_gmt":"2023-11-02T20:06:56","guid":{"rendered":"https:\/\/blog.officesupport.ru\/?p=617"},"modified":"2025-05-19T08:26:29","modified_gmt":"2025-05-19T05:26:29","slug":"%d0%b2%d0%be%d1%81%d1%81%d1%82%d0%b0%d0%bd%d0%be%d0%b2%d0%bb%d0%b5%d0%bd%d0%b8%d0%b5-mysql-%d0%b8%d0%b7-%d0%b4%d0%b0%d0%bc%d0%bf%d0%b0","status":"publish","type":"post","link":"https:\/\/blog.officesupport.ru\/?p=617","title":{"rendered":"\u0412\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 MySQL \u0438\u0437 \u0434\u0430\u043c\u043f\u0430"},"content":{"rendered":"\n<p>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0430\u0437\u044b:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>> CREATE DATABASE db DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>> CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'password';\n\n> GRANT ALL PRIVILEGES ON db.* TO 'dbuser'@'localhost';\n<\/code><\/pre>\n\n\n\n<p>\u0412\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0431\u0430\u0437\u044b:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gunzip \/tmp\/dump.sql.gz\nmysql -u root -p dbname &lt; \/tmp\/dump.sql<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0430\u0437\u044b: \u0412\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0431\u0430\u0437\u044b:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-617","post","type-post","status-publish","format-standard","hentry","category-it"],"_links":{"self":[{"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=\/wp\/v2\/posts\/617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=617"}],"version-history":[{"count":1,"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=\/wp\/v2\/posts\/617\/revisions"}],"predecessor-version":[{"id":679,"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=\/wp\/v2\/posts\/617\/revisions\/679"}],"wp:attachment":[{"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.officesupport.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}