Nginx phpmyadmin 和 magento 2 本地在 Ubuntu 上

Question

我目前正在本地 ubuntu 机器上运行 magento 2，我想安装 phpmyadmin，但我在让它实际工作时遇到了麻烦。

基本上，我希望phpmyadmin在本地运行，这样我就可以轻松管理我的数据库，而无需诉诸命令行。

我在/sites-enabled/和/sites-available/中的.conf文件如下所示：

upstream backend {
    server  127.0.0.1:9000;
}
server {
    listen localhost:80;
    server_name magento2.local.dev;
    set $MAGE_ROOT /home/janderson/magento2/;
    root $MAGE_ROOT/pub;
    index index.php;
    autoindex off;
    charset UTF-8;
    error_page 404 403 = /errors/404.php;
    # PHP entry point for setup application
    location ~* ^/setup($|/) {
        root $MAGE_ROOT;
        location ~ ^/setup/index.php {
            fastcgi_pass   backend;
            fastcgi_index  index.php;
            fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
            include        fastcgi_params;
        }
        location ~ ^/setup/(?!pub/). {
            deny all;
        }
        location ~ ^/setup/pub/ {
            add_header X-Frame-Options "SAMEORIGIN";
        }
    }
    # PHP entry point for update application
    location ~* ^/update($|/) {
        root $MAGE_ROOT;
        location ~ ^/update/index.php {
            fastcgi_split_path_info ^(/update/index.php)(/.+)$;
            fastcgi_pass   backend;
            fastcgi_index  index.php;
            fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
            fastcgi_param  PATH_INFO        $fastcgi_path_info;
            include        fastcgi_params;
        }
        # Deny everything but index.php
        location ~ ^/update/(?!pub/). {
            deny all;
        }
        location ~ ^/update/pub/ {
            add_header X-Frame-Options "SAMEORIGIN";
        }
    }
    location / {
        try_files $uri $uri/ /index.php?$args;
    }
    location /pub/ {
        location ~ ^/pub/media/(downloadable|customer|import|theme_customization/.*.xml) {
            deny all;
        }
        alias $MAGE_ROOT/pub/;
        add_header X-Frame-Options "SAMEORIGIN";
    }
    location /static/ {
        # Uncomment the following line in production mode
        # expires max;
        # Remove signature of the static files that is used to overcome the browser cache
        location ~ ^/static/version {
            rewrite ^/static/(versiond*/)?(.*)$ /static/$2 last;
        }
        location ~* .(ico|jpg|jpeg|png|gif|svg|js|css|swf|eot|ttf|otf|woff|woff2)$ {
            add_header Cache-Control "public";
            add_header X-Frame-Options "SAMEORIGIN";
            expires +1y;
            if (!-f $request_filename) {
                rewrite ^/static/(versiond*/)?(.*)$ /static.php?resource=$2 last;
            }
        }
        location ~* .(zip|gz|gzip|bz2|csv|xml)$ {
            add_header Cache-Control "no-store";
            add_header X-Frame-Options "SAMEORIGIN";
            expires    off;
            if (!-f $request_filename) {
               rewrite ^/static/(versiond*/)?(.*)$ /static.php?resource=$2 last;
            }
        }
        if (!-f $request_filename) {
            rewrite ^/static/(versiond*/)?(.*)$ /static.php?resource=$2 last;
        }
        add_header X-Frame-Options "SAMEORIGIN";
    }
    location /media/ {
        try_files $uri $uri/ /get.php?$args;
        location ~ ^/media/theme_customization/.*.xml {
            deny all;
        }
        location ~* .(ico|jpg|jpeg|png|gif|svg|js|css|swf|eot|ttf|otf|woff|woff2)$ {
            add_header Cache-Control "public";
            add_header X-Frame-Options "SAMEORIGIN";
            expires +1y;
            try_files $uri $uri/ /get.php?$args;
        }
        location ~* .(zip|gz|gzip|bz2|csv|xml)$ {
            add_header Cache-Control "no-store";
            add_header X-Frame-Options "SAMEORIGIN";
            expires    off;
            try_files $uri $uri/ /get.php?$args;
        }
        add_header X-Frame-Options "SAMEORIGIN";
    }
    location /media/customer/ {
        deny all;
    }
    location /media/downloadable/ {
        deny all;
    }
    location /media/import/ {
        deny all;
    }
    # PHP entry point for main application
    location ~ (index|get|static|report|404|503).php$ {
        try_files $uri =404;
        fastcgi_pass   backend;
        fastcgi_buffers 1024 4k;
        fastcgi_read_timeout 600s;
        fastcgi_connect_timeout 600s;
        fastcgi_index  index.php;
        fastcgi_param  SCRIPT_FILENAME  $document_root$fastcgi_script_name;
        include        fastcgi_params;
    }
    gzip on;
    gzip_disable "msie6";
    gzip_comp_level 6;
    gzip_min_length 1100;
    gzip_buffers 16 8k;
    gzip_proxied any;
    gzip_types
        text/plain
        text/css
        text/js
        text/xml
        text/javascript
        application/javascript
        application/x-javascript
        application/json
        application/xml
        application/xml+rss
        image/svg+xml;
    gzip_vary on;
    # Banned locations (only reached if the earlier PHP entry point regexes don't match)
    location ~* (.php$|.htaccess$|.git) {
        allow all;
    }
}
server {
    listen localhost:8080;
    server_name phpmyadmin.local;
    root /usr/share/phpmyadmin;
}

Answer 1

要在本地(甚至远程(管理数据库，我建议使用MysqlWorkbench或SequelPro而不是phpmyadmin

设置非常简单，您可以将localhost或127.0.0.1作为"主机"，然后更正端口号和用户名密码组合。