phpMyAdmin – How to Change phpMyAdmin Access URL

Apache2lampphpmyadmin

Could someone please tell me how to change phpMyAdmin's access URL, I would like it only to be accessible from a specific URL: database.example.com. example.com would be replaced to my actual domain.

I am running Ubuntu Server 14.04 LTS with LAMP and phpMyAdmin installed. I installed phpMyAdmin through command line using:

apt-get install phpmyadmin

Many Thanks,
Sam

Best Answer

For ubuntu (i used ubuntu 12.04), the default phpmyadmin apache configuration can be found at /etc/phpmyadmin/apache.conf

You can open it by type sudo nano /etc/phpmyadmin/apache.conf and change the third

Alias /yournewalias /usr/share/phpmyadmin

Do not forget to restart apache service,

sudo service apache2 restart

Related Solutions

Apache2 – Change Document Root Folder to Secondary Hard Drive

You'll have to edit apache2.conf and 000-default.conf to change the document root of apache.

The Apache server is installed on /var/www/html.This is the default root directory of apache.

Either change the root directory of Apache or move the project to /var/www/html.

To change Apache's root directory, run:
```
 cd /etc/apache2/sites-available
```
Then open the 000-default.conf file using the command:
```
 nano 000-default.conf
```
Edit the DocumentRoot option:
```
 DocumentRoot /path/to/my/project
```
Then restart the apache server:
```
 sudo service apache2 restart
```

If you get Forbidden You don't have permission to access / on this server after changing the root of apache then do follow these steps

Find the apache2.conf located in /etc/apache2 and open it using:
```
 nano apache2.conf
```
Use Ctrl+W and search for Directory (It should be in line 153)

It should look like this

 <Directory />
     Options Indexes FollowSymLinks
     AllowOverride All
     Require all denied
 </Directory>

Change it to

 <Directory />
     Options Indexes FollowSymLinks Includes ExecCGI
     AllowOverride All
     Require all granted
 </Directory>

Restart apache
```
 sudo service apache2 restart
```

I made a script that changes apache root in a single command. You can find it on my github.

Best Answer

Related Solutions

Apache2 – Change Document Root Folder to Secondary Hard Drive

Related Question