{"id":775,"date":"2018-06-08T23:24:14","date_gmt":"2018-06-08T19:24:14","guid":{"rendered":"https:\/\/bukleev.ru\/?page_id=775"},"modified":"2018-12-10T10:00:39","modified_gmt":"2018-12-10T06:00:39","slug":"mysql-%d1%81%d0%b5%d1%80%d0%b2%d0%b5%d1%80","status":"publish","type":"page","link":"https:\/\/bukleev.ru\/?page_id=775","title":{"rendered":"\u041a\u043e\u043c\u0430\u043d\u0434\u044b \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441 MySQL \u0441\u0435\u0440\u0432\u0435\u0440"},"content":{"rendered":"<p>\u0414\u043b\u044f \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0438\u0437 \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u043e\u0439 \u0441\u0435\u0442\u0438 \u043a \u0441\u0435\u0440\u0432\u0435\u0440\u0443 MySQL<\/p>\n<p>\u0417\u0430\u0445\u043e\u0434\u0438\u043c \u0432 \u043a\u043e\u043d\u0441\u043e\u043b\u044c MySQL<\/p>\n<pre>mysql -u root -p<\/pre>\n<p>\u041f\u043e\u0441\u043b\u0435 \u043f\u0440\u0438\u0433\u043b\u0430\u0448\u0435\u043d\u0438\u044f, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0442\u0430\u043a\u043e\u0433\u043e MariaDB&gt; \u043d\u0430\u0431\u0438\u0440\u0430\u0435\u043c<\/p>\n<pre>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '<strong>MYPASSWORD<\/strong>' WITH GRANT OPTION;\r\n\r\nFLUSH PRIVILEGES;<\/pre>\n<p>\u0422\u0435\u043c \u0441\u0430\u043c\u044b\u043c \u0434\u0430\u0435\u043c \u0434\u043e\u0441\u0442\u0443\u043f \u043a\u043e \u0432\u0441\u0435\u043c \u0431\u0430\u0437\u0430\u043c \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e root<\/p>\n<p>\u041e\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0430 MySQL<\/p>\n<pre><code>systemctl stop mariadb<\/code><\/pre>\n<p>\u0412\u043e\u0441\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0431\u0430\u0437\u044b<\/p>\n<pre>&gt; mysql -u \"user\" \u2013p db_name &lt; [path\\]db_name.sql\r\n\r\nmysql -u root -p  otrs &lt; DatabaseBackup.sql<\/pre>\n<p>\u0421\u043f\u0438\u0441\u043e\u043a \u0431\u0430\u0437<\/p>\n<pre>SHOW DATABASES;<\/pre>\n<p>\u0423\u0434\u0430\u043b\u0435\u043d\u0438\u0435 \u0431\u0430\u0437\u044b<\/p>\n<pre>DROP DATABASE otrs;<\/pre>\n<p>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0431\u0430\u0437\u044b<\/p>\n<pre>CREATE DATABASE IF NOT EXISTS otrs;\r\n<code><span class=\"kwd\">CREATE<\/span> <span class=\"kwd\">DATABASE<\/span><span class=\"pln\"> otrs CHARACTER <\/span><span class=\"kwd\">SET<\/span><span class=\"pln\"> utf8 <\/span><span class=\"kwd\">COLLATE<\/span><span class=\"pln\"> utf8_general_ci<\/span><span class=\"pun\">;<\/span><\/code><\/pre>\n<p>\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044f MySQL<\/p>\n<pre>CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'test123test!';<\/pre>\n<p>\u0421\u043f\u0438\u0441\u043e\u043a \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439 MySQL<\/p>\n<pre>SELECT User,Host FROM mysql.user;<\/pre>\n<p>\u041d\u0430\u0437\u043d\u0430\u0447\u0438\u0442\u044c \u043f\u0440\u0430\u0432\u0430 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u044e \u043d\u0430 \u0431\u0430\u0437\u0443<\/p>\n<pre>GRANT permission ON database.table TO 'user'@'localhost';<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0414\u043b\u044f \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0438\u0437 \u043b\u043e\u043a\u0430\u043b\u044c\u043d\u043e\u0439 \u0441\u0435\u0442\u0438 \u043a \u0441\u0435\u0440\u0432\u0435\u0440\u0443 MySQL \u0417\u0430\u0445\u043e\u0434\u0438\u043c \u0432 \u043a\u043e\u043d\u0441\u043e\u043b\u044c MySQL mysql -u root -p \u041f\u043e\u0441\u043b\u0435 \u043f\u0440\u0438\u0433\u043b\u0430\u0448\u0435\u043d\u0438\u044f, \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 \u0442\u0430\u043a\u043e\u0433\u043e MariaDB&gt; \u043d\u0430\u0431\u0438\u0440\u0430\u0435\u043c GRANT ALL PRIVILEGES ON *.* TO &#8216;root&#8217;@&#8217;%&#8217; IDENTIFIED BY &#8216;MYPASSWORD&#8217; WITH GRANT OPTION; FLUSH PRIVILEGES; \u0422\u0435\u043c \u0441\u0430\u043c\u044b\u043c \u0434\u0430\u0435\u043c<\/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-775","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=775"}],"version-history":[{"count":10,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/775\/revisions"}],"predecessor-version":[{"id":1033,"href":"https:\/\/bukleev.ru\/index.php?rest_route=\/wp\/v2\/pages\/775\/revisions\/1033"}],"wp:attachment":[{"href":"https:\/\/bukleev.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}