如何修改phpMyAdmin端口？改端口后仅显示index.php的解决方法

问题描述 #

将Apache端口从80修改为8033后，访问http://192.168.122.98:8033/仅显示index.php页面，此前该地址正常显示phpMyAdmin操作页面，需恢复phpMyAdmin的默认显示。

用户修改端口的操作步骤 #

$ sudo semanage port -l | grep -w http_port_t
http_port_t                    tcp      80, 443, 488, 8008, 8009, 8443, 8448
$ sudo vim /etc/apache2/sites-enabled/thost.conf
$ cat /etc/apache2/sites-enabled/thost.conf
<VirtualHost *:8033>
...
$ sudo vim /etc/apache2/ports.conf 
$ cat /etc/apache2/ports.conf 
...
Listen 8033
...
$ sudo systemctl restart apache2
$ sudo netstat -tlpn | grep apache
tcp6       0      0 :::8033                 :::*                    LISTEN      2452/apache2 
$ sudo semanage port -a -t http_port_t -p tcp 8033
$ sudo semanage port -l | grep -w http_port_t
http_port_t                    tcp      8033, 80, 443, 488, 8008, 8009, 8443, 8448
$ sudo ufw allow 8033
$ sudo systemctl restart apache2
$ google-chrome http://192.168.122.98:8033/

解决方案 #

1. 调整VirtualHost配置 #

编辑虚拟主机配置文件/etc/apache2/sites-enabled/thost.conf，确保<VirtualHost *:8033>块中将根路径指向phpMyAdmin，可选择以下两种方式：

• 设置DocumentRoot直接指向phpMyAdmin目录

  <VirtualHost *:8033>
      ServerAdmin webmaster@localhost
      DocumentRoot /usr/share/phpmyadmin
      
      <Directory /usr/share/phpmyadmin/>
          AllowOverride All
          Require all granted
      </Directory>
      
      ErrorLog ${APACHE_LOG_DIR}/error.log
      CustomLog ${APACHE_LOG_DIR}/access.log combined
  </VirtualHost>
  

• 用Alias映射根路径到phpMyAdmin
  若原有DocumentRoot需保留，可添加Alias规则：

  <VirtualHost *:8033>
      ServerAdmin webmaster@localhost
      DocumentRoot /var/www/html
      
      Alias / /usr/share/phpmyadmin/
      
      <Directory /usr/share/phpmyadmin/>
          AllowOverride All
          Require all granted
      </Directory>
      
      ErrorLog ${APACHE_LOG_DIR}/error.log
      CustomLog ${APACHE_LOG_DIR}/access.log combined
  </VirtualHost>
  

修改后重启Apache生效：

sudo systemctl restart apache2

2. 启用phpMyAdmin系统配置 #

执行命令启用phpMyAdmin的Apache全局配置：

sudo a2enconf phpmyadmin
sudo systemctl restart apache2

3. 修复文件权限 #

确保phpMyAdmin目录权限符合Apache访问要求：

sudo chown -R www-data:www-data /usr/share/phpmyadmin
sudo chmod -R 755 /usr/share/phpmyadmin

4. 测试备选访问路径 #

若上述操作后仍未恢复，尝试访问http://192.168.122.98:8033/phpmyadmin，若能正常显示，说明是根路径映射配置问题，需重新调整VirtualHost的DocumentRoot或Alias规则。

内容的提问来源于stack exchange，提问作者Dato