首页 > 解决方案 > 无法在 ubuntu 18.04、php 5.6 apache2 中访问 phpmyadmin

问题描述

我在sites-enabledapahce2 的目录中定义了两个虚拟主机

<VirtualHost *:80>
        # The ServerName directive sets the request scheme, hostname and port that
        # the server uses to identify itself. This is used when creating
        # redirection URLs. In the context of virtual hosts, the ServerName
        # specifies what hostname must appear in the request's Host: header to
        # match this virtual host. For the default virtual host (this file) this
        # value is not decisive as it is used as a last resort host regardless.
        # However, you must set it for any further virtual host explicitly.
        #ServerName www.example.com

         ServerAdmin webmaster@sub.domain.in
        ServerName sub.domain.in
        ServerAlias www.sub.domain
        DocumentRoot /var/www/html/sub/public_html

        # Available loglevels: trace8, ..., trace1, debug, info, notice, warn,
        # error, crit, alert, emerg.
        # It is also possible to configure the loglevel for particular
        # modules, e.g.
        #LogLevel info ssl:warn

        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined

        # For most configuration files from conf-available/, which are
        # enabled or disabled at a global level, it is possible to
        # include a line for only one particular virtual host. For example the
        # following line enables the CGI configuration for this host only
        # after it has been globally disabled with "a2disconf".
        #Include conf-available/serve-cgi-bin.conf
</VirtualHost>


   # vim: syntax=apache ts=4 sw=4 sts=4 sr noet
<VirtualHost *:443>
         ServerAdmin webmaster@sub.domain.in
        ServerName sub.domain.in
        ServerAlias www.sub.domain
        DocumentRoot /var/www/html/sub/public_html

        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined

        SSLEngine on
        SSLCertificateFile /home/ubuntu/sub.crt
        SSLCertificateKeyFile /home/ubuntu/sub.key
</VirtualHost>

此配置适用于所有子域,但是有一个问题我无法通过访问http://ip/phpmyadmin 我应该更改什么配置以使 phpmyadmin 可以使用 Web 服务器访问来访问 phpmyadmin。

标签: phpphpmyadminapache2ubuntu-18.04

解决方案


要在 apache2 中启用虚拟主机时访问 phpmyadmin,您只需sites-availablephpmyadmin.conf文件中使用以下配置为 phpmyadmin 创建另一个子域

<VirtualHost *:80>
   ServerAdmin adminn@example.local
   ServerName phpmyadmin.example.local
   DocumentRoot /usr/share/phpmyadmin
   <Directory />
       Options FollowSymLinks
       AllowOverride None
   </Directory>
   LogLevel notice
   CustomLog /var/log/apache2/access.log combined
   ErrorLog /var/log/apache2/error.log
   ServerSignature On
</VirtualHost>

在这之后做

sudo a2ensite phpmyadmin
sudo service apache2 reload

现在访问子域 phpmyadmin.mydomain.com 它应该就在那里

注意:如果您使用的是 ssl,您还必须在端口 443 上定义一个虚拟主机,并在同一个文件中使用 ssl 配置


推荐阅读