{"id":10314,"date":"2023-12-27T23:00:06","date_gmt":"2023-12-27T19:30:06","guid":{"rendered":"https:\/\/rasanegar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-phpmyadmin-%d8%a8%d8%a7-nginx-%d8%af%d8%b1-centos-7\/"},"modified":"2023-12-27T23:00:06","modified_gmt":"2023-12-27T19:30:06","slug":"%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-phpmyadmin-%d8%a8%d8%a7-nginx-%d8%af%d8%b1-centos-7","status":"publish","type":"post","link":"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-phpmyadmin-%d8%a8%d8%a7-nginx-%d8%af%d8%b1-centos-7\/","title":{"rendered":"\u0631\u0648\u0634 \u0646\u0635\u0628 phpMyAdmin \u0628\u0627 Nginx \u062f\u0631 CentOS 7"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\"><p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0633\u0631\u0641\u0635\u0644\u0647\u0627\u06cc \u0645\u0637\u0644\u0628<\/p>\n<\/div><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-phpmyadmin-%d8%a8%d8%a7-nginx-%d8%af%d8%b1-centos-7\/#%d9%be%db%8c%d8%b4_%d9%86%db%8c%d8%a7%d8%b2%d9%87%d8%a7\" >\u067e\u06cc\u0634 \u0646\u06cc\u0627\u0632\u0647\u0627<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-phpmyadmin-%d8%a8%d8%a7-nginx-%d8%af%d8%b1-centos-7\/#%d9%86%d8%b5%d8%a8_phpmyadmin_%d8%af%d8%b1_centos\" >\u0646\u0635\u0628 phpMyAdmin \u062f\u0631 CentOS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-phpmyadmin-%d8%a8%d8%a7-nginx-%d8%af%d8%b1-centos-7\/#%d9%be%db%8c%da%a9%d8%b1%d8%a8%d9%86%d8%af%db%8c_nginx_%d9%88_phpmyadmin\" >\u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc Nginx \u0648 phpMyAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-phpmyadmin-%d8%a8%d8%a7-nginx-%d8%af%d8%b1-centos-7\/#%d8%af%d8%b3%d8%aa%d8%b1%d8%b3%db%8c_%d8%a8%d9%87_phpmyadmin\" >\u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 phpMyAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/rasanegaar.com\/blog\/%d8%b1%d9%88%d8%b4-%d9%86%d8%b5%d8%a8-phpmyadmin-%d8%a8%d8%a7-nginx-%d8%af%d8%b1-centos-7\/#%d9%86%d8%aa%db%8c%d8%ac%d9%87\" >\u0646\u062a\u06cc\u062c\u0647<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u0632\u0645\u0627\u0646 \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u0645\u0637\u0627\u0644\u0639\u0647: <\/span> <span class=\"rt-time\"> 3<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span><p> <br \/>\n<br \/><\/p>\n<div class=\"markdown\">\n<p>phpMyAdmin \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u0645\u0646\u0628\u0639 \u0628\u0627\u0632 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 PHP \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u0633\u0631\u0648\u0631\u0647\u0627\u06cc MySQL \u0648 MariaDB \u0627\u0632 \u0637\u0631\u06cc\u0642 \u06cc\u06a9 \u0631\u0627\u0628\u0637 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0648\u0628 \u0627\u0633\u062a.<\/p>\n<p>phpMyAdmin \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 MySQL \u062a\u0639\u0627\u0645\u0644 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f\u060c \u062d\u0633\u0627\u0628 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc \u0648 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0631\u0627 \u0645\u062f\u06cc\u0631\u06cc\u062a \u06a9\u0646\u06cc\u062f\u060c \u0628\u06cc\u0627\u0646\u06cc\u0647 \u0647\u0627\u06cc SQL \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f\u060c \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u062f\u0627\u062f\u0647 \u0648\u0627\u0631\u062f \u0648 \u0635\u0627\u062f\u0631 \u06a9\u0646\u06cc\u062f \u0648 \u0645\u0648\u0627\u0631\u062f \u062f\u06cc\u06af\u0631.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0648\u0634 \u0646\u0635\u0628 phpMyAdmin \u0628\u0627 Nginx \u0631\u0627 \u0628\u0647 \u0634\u0645\u0627 \u0646\u0634\u0627\u0646 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f CentOS 7.<\/p>\n<h2 id=\"prerequisites\"><span class=\"ez-toc-section\" id=\"%d9%be%db%8c%d8%b4_%d9%86%db%8c%d8%a7%d8%b2%d9%87%d8%a7\"><\/span>\u067e\u06cc\u0634 \u0646\u06cc\u0627\u0632\u0647\u0627 <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0642\u0628\u0644 \u0627\u0632 \u0627\u062f\u0627\u0645\u0647 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u067e\u06cc\u0634 \u0646\u06cc\u0627\u0632\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f:<\/p>\n<ul>\n<li>LEMP (Linux\u060c Nginx\u060c MySQL\u060c \u0648 PHP 7) \u0631\u0648\u06cc \u0634\u0645\u0627 \u0646\u0635\u0628 \u0634\u062f\u0647 \u0627\u0633\u062a CentOS \u0633\u0631\u0648\u0631 .<\/li>\n<li>\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 \u0628\u0627 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a sudo \u0648\u0627\u0631\u062f \u0633\u06cc\u0633\u062a\u0645 \u0634\u062f\u0647\u200c\u0627\u06cc\u062f.<\/li>\n<\/ul>\n<p>\u0627\u06af\u0631\u0686\u0647 \u0636\u0631\u0648\u0631\u06cc \u0646\u06cc\u0633\u062a\u060c \u062a\u0648\u0635\u06cc\u0647 \u0645\u06cc \u0634\u0648\u062f \u0628\u0647 \u0646\u0635\u0628 phpMyAdmin \u062e\u0648\u062f \u0627\u0632 \u0637\u0631\u06cc\u0642 HTTPS \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.  \u0627\u06af\u0631 SSL \u062f\u0631 \u0633\u0627\u06cc\u062a \u0647\u0627\u06cc \u062e\u0648\u062f \u0646\u062f\u0627\u0631\u06cc\u062f\u060c \u062f\u0633\u062a\u0648\u0631\u0627\u0644\u0639\u0645\u0644 \u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0627\u06cc\u0645\u0646 \u0633\u0627\u0632\u06cc Nginx \u062e\u0648\u062f \u0631\u0627 \u0628\u0627 Let&#8217;s Encrypt on \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f. CentOS 7 .<\/p>\n<h2 id=\"installing-phpmyadmin-on-centos\"><span class=\"ez-toc-section\" id=\"%d9%86%d8%b5%d8%a8_phpmyadmin_%d8%af%d8%b1_centos\"><\/span>\u0646\u0635\u0628 phpMyAdmin \u062f\u0631 CentOS <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0631\u0627\u06cc \u0646\u0635\u0628 phpMyAdmin \u0631\u0648\u06cc a \u0627\u0632 \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f CentOS \u0633\u06cc\u0633\u062a\u0645 7:<\/p>\n<ol>\n<li>\n<p>phpMyAdmin \u062f\u0631 \u0645\u062e\u0632\u0646 EPEL \u06af\u0646\u062c\u0627\u0646\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.  \u0627\u06af\u0631 \u0642\u0628\u0644\u0627\u064b EPEL \u0631\u0627 \u0641\u0639\u0627\u0644 \u0646\u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0628\u0627 \u062a\u0627\u06cc\u067e \u06a9\u0631\u062f\u0646 \u0632\u06cc\u0631 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo yum install epel-release<\/code><\/pre>\n<\/li>\n<li>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0645\u062e\u0632\u0646 EPEL \u0641\u0639\u0627\u0644 \u0634\u062f\u060c phpMyAdmin \u0648 \u062a\u0645\u0627\u0645 \u0648\u0627\u0628\u0633\u062a\u06af\u06cc \u0647\u0627\u06cc \u0622\u0646 \u0631\u0627 \u0628\u0627 \u062f\u0633\u062a\u0648\u0631 \u0632\u06cc\u0631 \u0646\u0635\u0628 \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo yum install phpmyadmin<\/code><\/pre>\n<p><em>\u0642\u0628\u0644 \u0627\u0632 \u0646\u0635\u0628 phpMyAdmin \u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 Nginx \u0648 PHP 7 \u0631\u0627 \u0631\u0648\u06cc \u0633\u06cc\u0633\u062a\u0645 \u062e\u0648\u062f \u0646\u0635\u0628 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f.<\/em><\/p>\n<\/li>\n<li>\n<p>\u0645\u0627\u0644\u06a9\u06cc\u062a \u06af\u0631\u0648\u0647 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f <code>\/etc\/phpMyAdmin<\/code> \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0628\u0647 <code>nginx<\/code> (\u06a9\u0627\u0631\u0628\u0631\u06cc \u06a9\u0647 \u0633\u0631\u0648\u06cc\u0633 PHP FPM \u062a\u062d\u062a \u0622\u0646 \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f):<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo chgrp -R nginx \/etc\/phpMyAdmin<\/code><\/pre>\n<\/li>\n<\/ol>\n<h2 id=\"configuring-nginx-and-phpmyadmin\"><span class=\"ez-toc-section\" id=\"%d9%be%db%8c%da%a9%d8%b1%d8%a8%d9%86%d8%af%db%8c_nginx_%d9%88_phpmyadmin\"><\/span>\u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc Nginx \u0648 phpMyAdmin <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0631\u0627\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0628\u0631\u0627\u06cc \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc Nginx \u0628\u0631\u0627\u06cc \u0627\u0631\u0627\u0626\u0647 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc phpMyAdmin \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.  \u0627\u06af\u0631 \u0628\u0644\u0648\u06a9 \u0633\u0631\u0648\u0631 \u062f\u0627\u0645\u0646\u0647 \u0634\u0645\u0627 \u0627\u0632 \u0642\u0628\u0644 \u0628\u0631\u0627\u06cc \u0627\u0631\u0627\u0626\u0647 \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0647\u0627\u06cc PHP \u062a\u0646\u0638\u06cc\u0645 \u0634\u062f\u0647 \u0627\u0633\u062a\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0647 \u0633\u0627\u062f\u06af\u06cc \u06cc\u06a9 \u067e\u06cc\u0648\u0646\u062f \u0646\u0645\u0627\u062f\u06cc\u0646 \u0627\u0632 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0646\u0635\u0628 phpMyAdmin \u0628\u0647 \u062f\u0627\u06cc\u0631\u06a9\u062a\u0648\u0631\u06cc \u0631\u06cc\u0634\u0647 \u0633\u0646\u062f \u062f\u0627\u0645\u0646\u0647 \u062e\u0648\u062f \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627 \u06cc\u06a9 \u0642\u0637\u0639\u0647 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u0645 \u0622\u0646 \u0631\u0627 \u062f\u0631 \u0647\u0631 \u06cc\u06a9 \u0627\u0632 \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0628\u0644\u0648\u06a9 \u0633\u0631\u0648\u0631 Nginx \u062e\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u0645.<\/p>\n<p>\u0628\u0627 \u0627\u06cc\u062c\u0627\u062f \u0622\u0646 \u0634\u0631\u0648\u0639 \u06a9\u0646\u06cc\u062f <code>snippets<\/code> \u0641\u0647\u0631\u0633\u062a \u0631\u0627\u0647\u0646\u0645\u0627:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo mkdir -p \/etc\/nginx\/snippets<\/code><\/pre>\n<p>\u0648\u06cc\u0631\u0627\u06cc\u0634\u06af\u0631 \u0645\u062a\u0646 \u062e\u0648\u062f \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f \u0648 \u0641\u0627\u06cc\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f:<\/p>\n<pre class=\"terminal\"><code class=\"terminal-line\" prefix=\"$\">sudo nano \/etc\/nginx\/snippets\/phpMyAdmin.conf<\/code><\/pre>\n<p>\u0645\u062d\u062a\u0648\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0686\u0633\u0628\u0627\u0646\u06cc\u062f:<\/p>\n<div class=\"code-label\">\/etc\/nginx\/snippets\/phpMyAdmin.conf<\/div>\n<div class=\"highlight\">\n<pre tabindex=\"0\" class=\"chroma\"><code class=\"language-nginx\" data-lang=\"nginx\"><span class=\"line\"><span class=\"cl\"><span class=\"k\">location<\/span> <span class=\"s\">\/phpMyAdmin<\/span> <span class=\"p\">{<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">       <span class=\"kn\">root<\/span> <span class=\"s\">\/usr\/share\/<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">       <span class=\"kn\">index<\/span> <span class=\"s\">index.php<\/span> <span class=\"s\">index.html<\/span> <span class=\"s\">index.htm<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">       <span class=\"kn\">location<\/span> <span class=\"p\">~<\/span> <span class=\"sr\">^\/phpMyAdmin\/(.+\\.php)$<\/span> <span class=\"p\">{<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">               <span class=\"kn\">try_files<\/span> <span class=\"nv\">$uri<\/span> <span class=\"p\">=<\/span><span class=\"mi\">404<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">               <span class=\"kn\">root<\/span> <span class=\"s\">\/usr\/share\/<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">               <span class=\"kn\">fastcgi_pass<\/span> <span class=\"s\">unix:\/run\/php-fpm\/www.sock<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">               <span class=\"kn\">fastcgi_index<\/span> <span class=\"s\">index.php<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">               <span class=\"kn\">fastcgi_param<\/span> <span class=\"s\">SCRIPT_FILENAME<\/span> <span class=\"nv\">$document_root$fastcgi_script_name<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">               <span class=\"kn\">include<\/span> <span class=\"s\">\/etc\/nginx\/fastcgi_params<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">       <span class=\"p\">}<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">       <span class=\"kn\">location<\/span> <span class=\"p\">~<\/span><span class=\"sr\">*<\/span> <span class=\"s\">^\/phpMyAdmin\/(.+\\.(jpg|jpeg|gif|css|png|js|ico|html|xml|txt))<\/span>$ <span class=\"p\">{<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">               <span class=\"kn\">root<\/span> <span class=\"s\">\/usr\/share\/<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">       <span class=\"p\">}<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"p\">}<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"k\">location<\/span> <span class=\"s\">\/phpmyadmin<\/span> <span class=\"p\">{<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">    <span class=\"kn\">rewrite<\/span> <span class=\"s\">^\/*<\/span> <span class=\"s\">\/phpMyAdmin<\/span> <span class=\"s\">last<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"p\">}<\/span>\n<\/span><\/span><\/code><\/pre>\n<\/div>\n<div class=\"note bg-yellow-100 dark:bg-gray-800 border-l-4 border-yellow-400 dark:text-yellow-200 p-6 my-6\">\n<div class=\"flex\">\n<div class=\"font-sans w-full\">\u0645\u0637\u0645\u0626\u0646 \u0634\u0648\u06cc\u062f \u06a9\u0647 \u0627\u0632 \u0645\u0633\u06cc\u0631 \u0633\u0648\u06a9\u062a \u06cc\u0627 \u0622\u062f\u0631\u0633\/\u067e\u0648\u0631\u062a \u0635\u062d\u06cc\u062d \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f <code>fastcgi_pass<\/code> \u0628\u062e\u0634\u0646\u0627\u0645\u0647<\/div>\n<\/div>\n<\/div>\n<p>\u0641\u0627\u06cc\u0644 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u06cc\u062f \u0648 \u0648\u06cc\u0631\u0627\u06cc\u0634\u06af\u0631 \u062e\u0648\u062f \u0631\u0627 \u0628\u0628\u0646\u062f\u06cc\u062f.<\/p>\n<p>\u0627\u06a9\u0646\u0648\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062e\u0637 \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u0628\u0644\u0648\u06a9 \u0633\u0631\u0648\u0631 \u0647\u0631 \u062f\u0627\u0645\u0646\u0647 \u06a9\u0647 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0622\u0646 \u0628\u0647 phpMyAdmin \u062f\u0633\u062a\u0631\u0633\u06cc \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f\u060c \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f: <code>domain.com\/phpmyadmin<\/code><\/p>\n<div class=\"highlight\">\n<pre tabindex=\"0\" class=\"chroma\"><code class=\"language-nginx\" data-lang=\"nginx\"><span class=\"line\"><span class=\"cl\"><span class=\"k\">include<\/span> <span class=\"n\">snippets\/phpMyAdmin.conf<\/span>;\n<\/span><\/span><\/code><\/pre>\n<\/div>\n<p>\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644:<\/p>\n<div class=\"code-label\">\/etc\/nginx\/conf.d\/domain.com.conf<\/div>\n<div class=\"highlight\">\n<pre tabindex=\"0\" class=\"chroma\"><code class=\"language-nginx\" data-lang=\"nginx\"><span class=\"line\"><span class=\"cl\"><span class=\"k\">server<\/span> <span class=\"p\">{<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">\n<\/span><\/span><span class=\"line\"><span class=\"cl\">    <span class=\"c1\"># . . . other code\n<\/span><\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"c1\"><\/span>\n<\/span><\/span><span class=\"line hl\"><span class=\"cl\">    <span class=\"kn\">include<\/span> <span class=\"s\">snippets\/phpMyAdmin.conf<\/span><span class=\"p\">;<\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\">\n<\/span><\/span><span class=\"line\"><span class=\"cl\">    <span class=\"c1\"># . . . other code\n<\/span><\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"c1\"><\/span>\n<\/span><\/span><span class=\"line\"><span class=\"cl\"><span class=\"p\">}<\/span><\/span><\/span><\/code><\/pre>\n<\/div>\n<h2 id=\"accessing-phpmyadmin\"><span class=\"ez-toc-section\" id=\"%d8%af%d8%b3%d8%aa%d8%b1%d8%b3%db%8c_%d8%a8%d9%87_phpmyadmin\"><\/span>\u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 phpMyAdmin <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0628\u0631\u0627\u06cc \u062f\u0633\u062a\u0631\u0633\u06cc \u0628\u0647 \u0631\u0627\u0628\u0637 phpMyAdmin \u0645\u0631\u0648\u0631\u06af\u0631 \u0645\u0648\u0631\u062f \u0639\u0644\u0627\u0642\u0647 \u062e\u0648\u062f \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f \u0648 \u0646\u0627\u0645 \u062f\u0627\u0645\u0646\u0647 \u06cc\u0627 \u0622\u062f\u0631\u0633 IP \u0639\u0645\u0648\u0645\u06cc \u0633\u0631\u0648\u0631 \u062e\u0648\u062f \u0631\u0627 \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0622\u0646 \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f <code>\/phpmyadmin<\/code>:<\/p>\n<pre tabindex=\"0\"><code class=\"language-url\" data-lang=\"url\">http(s):\/\/your_domain_or_ip_address\/phpmyadmin\n<\/code><\/pre>\n<p>\u0627\u0639\u062a\u0628\u0627\u0631 \u0648\u0631\u0648\u062f \u06a9\u0627\u0631\u0628\u0631 \u0627\u062f\u0627\u0631\u06cc \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0631\u062f\u0647 \u0648 \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f <code>Go<\/code>.<\/p>\n<figure class=\"relative\">\n<div class=\"relative block w-full mx-auto my-0\">\n<div class=\"bg-gray-100 absolute inset-0 w-full h-full m-auto overflow-hidden\"><img decoding=\"async\" class=\"absolute inset-0 w-full h-full m-auto\" loading=\"lazy\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703705405_945_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-phpMyAdmin-\u0628\u0627-Nginx-\u062f\u0631-CentOS-7.jpg\" alt=\"\u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 phpmyadmin\" title=\"\"><\/div>\n<\/div>\n<\/figure>\n<p>\u067e\u0633 \u0627\u0632 \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645\u060c \u062f\u0627\u0634\u0628\u0648\u0631\u062f phpMyAdmin \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f \u06a9\u0647 \u0686\u06cc\u0632\u06cc \u0634\u0628\u06cc\u0647 \u0628\u0647 \u0627\u06cc\u0646 \u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f:<\/p>\n<figure class=\"relative\">\n<div class=\"relative block w-full mx-auto my-0\">\n<div class=\"bg-gray-100 absolute inset-0 w-full h-full m-auto overflow-hidden\"><img decoding=\"async\" class=\"absolute inset-0 w-full h-full m-auto\" loading=\"lazy\" src=\"https:\/\/rasanegar.com\/blog\/wp-content\/uploads\/2023\/12\/1703705406_620_\u0646\u062d\u0648\u0647-\u0646\u0635\u0628-phpMyAdmin-\u0628\u0627-Nginx-\u062f\u0631-CentOS-7.jpg\" alt=\"\u0631\u0627\u0628\u0637 phpmyadmin\" title=\"\"><\/div>\n<\/div>\n<\/figure>\n<h2 id=\"conclusion\"><span class=\"ez-toc-section\" id=\"%d9%86%d8%aa%db%8c%d8%ac%d9%87\"><\/span>\u0646\u062a\u06cc\u062c\u0647 <span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062a\u0628\u0631\u06cc\u06a9 \u0645\u06cc \u06af\u0648\u06cc\u0645\u060c \u0634\u0645\u0627 \u0628\u0627 \u0645\u0648\u0641\u0642\u06cc\u062a phpMyAdmin \u0631\u0627 \u0628\u0631 \u0631\u0648\u06cc \u062e\u0648\u062f \u0646\u0635\u0628 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f CentOS 7 \u0633\u0631\u0648\u0631.  \u0627\u06a9\u0646\u0648\u0646 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0634\u0631\u0648\u0639 \u0628\u0647 \u0627\u06cc\u062c\u0627\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647\u060c \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0648 \u062c\u062f\u0627\u0648\u0644 MySQL \u06a9\u0646\u06cc\u062f \u0648 \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627 \u0648 \u0639\u0645\u0644\u06cc\u0627\u062a \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 MySQL \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f.<\/p>\n<p>\u0627\u06af\u0631 \u0633\u0648\u0627\u0644\u06cc \u062f\u0627\u0631\u06cc\u062f\u060c \u062f\u0631 \u0632\u06cc\u0631 \u0646\u0638\u0631 \u062f\u0647\u06cc\u062f.<\/p>\n<div class=\"flex flex-wrap my-8\">centos phpmyadmin mysql mariadb nginx php<\/div>\n<\/div>\n\n<div>\u0628\u0631\u0627\u06cc \u0646\u06af\u0627\u0631\u0634 \u0628\u062e\u0634\u0647\u0627\u06cc\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u0645\u062a\u0646 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0627\u0632 \u062a\u0631\u062c\u0645\u0647 \u0645\u0627\u0634\u06cc\u0646\u06cc \u06cc\u0627 \u0647\u0648\u0634 \u0645\u0635\u0646\u0648\u0639\u06cc GPT \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u0628\u0627\u0634\u062f <br \/>\n\u0644\u0637\u0641\u0627 \u062f\u0631 \u0635\u0648\u0631\u062a \u0648\u062c\u0648\u062f \u0645\u0634\u06a9\u0644 \u062f\u0631 \u0645\u062a\u0646 \u06cc\u0627 \u0645\u0641\u0647\u0648\u0645 \u0646\u0628\u0648\u062f\u0646 \u062a\u0648\u0636\u06cc\u062d\u0627\u062a\u060c \u0627\u0632 \u0637\u0631\u06cc\u0642 \u062f\u06a9\u0645\u0647 \u06af\u0632\u0627\u0631\u0634 \u0646\u0648\u0634\u062a\u0627\u0631 \u06cc\u0627 \u062f\u0631\u062c \u0646\u0638\u0631 \u0631\u0648\u06cc \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0645\u0627 \u0631\u0627 \u0627\u0632 \u062c\u0632\u06cc\u06cc\u0627\u062a \u0645\u0634\u06a9\u0644 \u0645\u0634\u0627\u0647\u062f\u0647 \u0634\u062f\u0647 \u0645\u0637\u0644\u0639 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u0647 \u0622\u0646 \u0631\u0633\u06cc\u062f\u06af\u06cc \u06a9\u0646\u06cc\u0645\n<\/div>\n<p>\u0632\u0645\u0627\u0646 \u0627\u0646\u062a\u0634\u0627\u0631: 1402-12-27 23:00:02<br \/>\n<\/p>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;10314&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;\u0627\u0645\u062a\u06cc\u0627\u0632 \u0634\u0645\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628&quot;,&quot;legend&quot;:&quot;0\\\/5 (0 \u0631\u0627\u06cc)&quot;,&quot;size&quot;:&quot;30&quot;,&quot;title&quot;:&quot;\u0631\u0648\u0634 \u0646\u0635\u0628 phpMyAdmin \u0628\u0627 Nginx \u062f\u0631 CentOS 7&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} ({count} \u0631\u0627\u06cc)&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 30px; height: 30px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 24px;\">\n            <span class=\"kksr-muted\">\u0627\u0645\u062a\u06cc\u0627\u0632 \u0634\u0645\u0627 \u0628\u0647 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"span-reading-time rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">\u0632\u0645\u0627\u0646 \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u0645\u0637\u0627\u0644\u0639\u0647: <\/span> <span class=\"rt-time\"> 3<\/span> <span class=\"rt-label rt-postfix\">\u062f\u0642\u06cc\u0642\u0647<\/span><\/span>phpMyAdmin \u06cc\u06a9 \u0627\u0628\u0632\u0627\u0631 \u0645\u0646\u0628\u0639 \u0628\u0627\u0632 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 PHP \u0628\u0631\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u0633\u0631\u0648\u0631\u0647\u0627\u06cc MySQL \u0648 MariaDB \u0627\u0632 \u0637\u0631\u06cc\u0642 \u06cc\u06a9 \u0631\u0627\u0628\u0637 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u0648\u0628 \u0627\u0633\u062a. phpMyAdmin \u0628\u0647 \u0634\u0645\u0627 \u0627\u0645\u06a9\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u0628\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 MySQL \u062a\u0639\u0627\u0645\u0644 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f\u060c \u062d\u0633\u0627\u0628 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc \u0648 \u0627\u0645\u062a\u06cc\u0627\u0632\u0627\u062a \u0631\u0627 \u0645\u062f\u06cc\u0631\u06cc\u062a \u06a9\u0646\u06cc\u062f\u060c \u0628\u06cc\u0627\u0646\u06cc\u0647 \u0647\u0627\u06cc SQL \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f\u060c \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":10315,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[202,95],"tags":[424,910,26,421,2530,2529,2537,2533,2539,2572],"class_list":{"0":"post-10314","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-os","8":"category-linux","9":"tag-mysql","10":"tag-nginx","11":"tag-php","12":"tag-phpmyadmin","13":"tag--linux","14":"tag-2529","16":"tag-2533","17":"tag-2539","18":"tag-2572"},"acf":[],"_links":{"self":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/10314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/comments?post=10314"}],"version-history":[{"count":0,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/posts\/10314\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media\/10315"}],"wp:attachment":[{"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/media?parent=10314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/categories?post=10314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rasanegaar.com\/blog\/wp-json\/wp\/v2\/tags?post=10314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}