{"id":2520,"date":"2017-11-02T10:44:17","date_gmt":"2017-11-02T10:44:17","guid":{"rendered":"https:\/\/tst-amo.pp.ua\/blog\/?p=2520"},"modified":"2017-11-03T14:50:58","modified_gmt":"2017-11-03T14:50:58","slug":"phpmyadmin","status":"publish","type":"post","link":"https:\/\/tst-amo.net.ua\/blog\/?p=2520","title":{"rendered":"phpmyadmin"},"content":{"rendered":"<p>\u0414\u043b\u044f Apache \u0438\u043b\u0438 Lighttp<\/p>\n<pre>apt-get install phpmyadmin<\/pre>\n<p>\u0432\u0441\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0441\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438.<\/p>\n<p>\u0414\u043b\u044f Nginx, \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u044d\u0442\u043e, \u0432 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u043c \u0440\u0435\u0436\u0438\u043c\u0435, \u043d\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u0441\u044f, \u043f\u0440\u0438\u0434\u0435\u0442\u0441\u044f \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u043f\u043e\u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0440\u0443\u043a\u0430\u043c\u0438, \u043d\u043e \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u0442\u0441\u044f \u043d\u0435 \u0445\u0443\u0436\u0435.<\/p>\n<pre>apt-get install phpmyadmin<\/pre>\n<p>\u041d\u0430 \u0432\u043e\u043f\u0440\u043e\u0441 &#8220;\u0441 \u043a\u0430\u043a\u0438\u043c\u0438 \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u043c\u0438 \u043c\u044b \u0431\u0443\u0434\u0435\u043c \u0435\u0433\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c&#8221;, \u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u043f\u0443\u0441\u0442\u044b\u043c\u0438.<\/p>\n<p>\u041e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u043d\u0430 \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435<\/p>\n<pre>nano \/etc\/nginx\/sites-available\/default<\/pre>\n<p>\u0438 \u0432 \u0441\u0435\u043a\u0446\u0438\u044e server {&#8230;} \u0434\u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u043c \u0432\u043d\u0438\u0437\u0443<\/p>\n<pre>#phpMyAdmin\r\n location \/phpmyadmin {\r\n     #root \/usr\/share\/;\r\n     index index.php index.html index.htm;\r\n location ~ ^\/phpmyadmin\/(.+\\.php)$ {\r\n     try_files $uri $uri\/ =404;\r\n     root \/usr\/share\/;\r\n     fastcgi_pass unix:\/var\/run\/php\/php7<span style=\"color: #ff0000;\">.1<\/span>-fpm.sock;\r\n     #fastcgi_pass 127.0.0.1:9000;\r\n     fastcgi_index index.php;\r\n     fastcgi_param SCRIPT_FILENAME $request_filename;\r\n     include \/etc\/nginx\/fastcgi_params;\r\n     }\r\n location ~* ^\/phpmyadmin\/(.+\\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))$ {\r\n     root \/usr\/share\/;\r\n     }\r\n }\r\n location \/phpMyAdmin {\r\n     rewrite ^\/* \/phpmyadmin last;\r\n     }\r\n<\/pre>\n<p>\u0414\u043b\u044f Debian \u0434\u0435\u043b\u0430\u0435\u043c \u0441\u0438\u043c\u0432\u043e\u043b\u044c\u043d\u0443\u044e \u0441\u0441\u044b\u043b\u043a\u0443<\/p>\n<pre> ln -s \/usr\/share\/phpmyadmin \/var\/www\/html\/<\/pre>\n<p>\u041f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441 \u0438 \u043f\u0435\u0440\u0435\u0437\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c:<\/p>\n<pre>nginx -t\r\nservice nginx restart<\/pre>\n<p>\u0414\u043b\u044f Debian 9:<\/p>\n<pre>mysql -u root -p <span style=\"color: #ff0000;\">mysql<\/span>\r\nEnter password:\r\n\r\nMariaDB [mysql]&gt; update user set plugin='' where user='root';\r\nQuery OK, 1 row affected (0.00 sec)\r\nRows matched: 1 Changed: 1 Warnings: 0\r\n\r\nMariaDB [mysql]&gt; flush privileges;\r\nQuery OK, 0 rows affected (0.01 sec)\r\n\r\nMariaDB [mysql]&gt; exit\r\nBye<\/pre>\n<p>\u041f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u043c<\/p>\n<pre>http:\/\/192.168.0.1\/phpmyadmin\/<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div class=\"pdfprnt-buttons pdfprnt-buttons-post pdfprnt-bottom-right\"><a href=\"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=wpv2posts2520&print=pdf\" class=\"pdfprnt-button pdfprnt-button-pdf\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/tst-amo.net.ua\/blog\/wp-content\/plugins\/pdf-print\/images\/pdf.png\" alt=\"image_pdf\" title=\"View PDF\" \/><\/a><a href=\"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=wpv2posts2520&print=print\" class=\"pdfprnt-button pdfprnt-button-print\" target=\"_blank\"><img decoding=\"async\" src=\"https:\/\/tst-amo.net.ua\/blog\/wp-content\/plugins\/pdf-print\/images\/print.png\" alt=\"image_print\" title=\"Print Content\" \/><\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>\u0414\u043b\u044f Apache \u0438\u043b\u0438 Lighttp apt-get install phpmyadmin \u0432\u0441\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u0441\u044f \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u0438. \u0414\u043b\u044f Nginx, \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u044d\u0442\u043e, \u0432 \u0430\u0432\u0442\u043e\u043c\u0430\u0442\u0438\u0447\u0435\u0441\u043a\u043e\u043c \u0440\u0435\u0436\u0438\u043c\u0435, \u043d\u0435 \u043f\u043e\u043b\u0443\u0447\u0438\u0442\u0441\u044f, \u043f\u0440\u0438\u0434\u0435\u0442\u0441\u044f \u043d\u0435\u043c\u043d\u043e\u0433\u043e \u043f\u043e\u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0440\u0443\u043a\u0430\u043c\u0438, \u043d\u043e \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u043f\u043e\u043b\u0443\u0447\u0430\u0435\u0442\u0441\u044f \u043d\u0435 \u0445\u0443\u0436\u0435. apt-get install phpmyadmin \u041d\u0430 \u0432\u043e\u043f\u0440\u043e\u0441 &#8220;\u0441 \u043a\u0430\u043a\u0438\u043c\u0438 \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u043c\u0438 \u043c\u044b \u0431\u0443\u0434\u0435\u043c \u0435\u0433\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c&#8221;, \u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u043c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u043f\u0443\u0441\u0442\u044b\u043c\u0438. \u041e\u0442\u043a\u0440\u044b\u0432\u0430\u0435\u043c \u043d\u0430 \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 nano \/etc\/nginx\/sites-available\/default \u0438 \u0432 \u0441\u0435\u043a\u0446\u0438\u044e server {&#8230;} \u0434\u043e\u043f\u0438\u0441\u044b\u0432\u0430\u0435\u043c &#8230;<\/p>\n<p><a href=\"https:\/\/tst-amo.net.ua\/blog\/?p=2520\" class=\"more-link\">Continue reading &lsquo;phpmyadmin&rsquo; &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47,99,82],"tags":[],"class_list":["post-2520","post","type-post","status-publish","format-standard","hentry","category-linux","category-nginx","category-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2520"}],"collection":[{"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2520"}],"version-history":[{"count":7,"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2520\/revisions"}],"predecessor-version":[{"id":2544,"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2520\/revisions\/2544"}],"wp:attachment":[{"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tst-amo.net.ua\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}