change phpmyadmin url through /etc/apache2/conf-available.phpmyadmin.conf

Question

I am using ubuntu 16.04 hosted in digital ocean

I want to change phpmyadmin access url. I saw link but they gave 2 options :

1) /etc/phpmyadmin/apache.conf - I tried, no luck.

2) /etc/apache2/conf-available/phpmyadmin.conf , but here instead of conf file type, its displaying as Readbale folder what wrong here ?

Possible duplicate of Change phpMyAdmin port from 80 to another number also How to secure phpmyadmin — pa4080, Oct 26 '17 at 10:16
@pa4080 Thanks for your comment, i went through that link, i dont want to change the port but i want to change phpmyadmin access url path...... — spylh9999ggr, Oct 26 '17 at 10:24
I'm sorry, I messed up the links. The first one can give you a general view to the configuration of phpmyadmin. The first part of the second one should be that you are looking for. I will write a short answer. — pa4080, Oct 26 '17 at 10:43

pa4080 · Accepted Answer · 2017-10-26T21:19:19.227

3

Actually /etc/apache2/conf-available/phpmyadmin.conf, that is displayed as 'folder', is a symbolic link to /etc/phpmyadmin/apache.conf:

$ ls -l /etc/apache2/conf-available/phpmyadmin.conf

lrwxrwxrwx 1 root root 28 яну 20  2017 /etc/apache2/conf-available/phpmyadmin.conf -> ../../phpmyadmin/apache.conf

To change the URI (access path) of PhpMyAdmin. Edit /etc/phpmyadmin/apache.conf and change the first path (/phpmyadmin) of this directive:

Alias /phpmyadmin /usr/share/phpmyadmin

Explanation about the directive Alias. Let's assume that DocumentRoot is /var/www/html. In this case the directive Alias /phpmyadmin /usr/share/phpmyadmin will serve as this symlink:
```
ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin
```

References:

How to secure phpmyadmin
Change phpMyAdmin port from 80 to another number (here are explained the basics about the default the configuration)

Update from the discussion: Indeed phpmyadmin.conf wasn't enabled, because the symbolic link /etc/apache2/conf-enabled/phpmyadmin.conf was missing. PhpMyAdmin was enabled within Apache's configuration by a symbolic link, created in /var/www/html, exactly as the above example. So the steps we perform were:

Tweak the Alias directive in /etc/phpmyadmin/apache.conf;
Enable phpmyadmin.conf: sudo a2enconf phpmyadmin.conf;
Restart Apache: sudo systemctl restart apache2.service;
Check whether the new URI path works;
Remove the unnecessary symbolic link: sudo rm /var/www/html/phpmyadmin.

edited Oct 26 '17 at 21:19

answered Oct 26 '17 at 10:31

pa4080

29,831

Thanks, i checked as here : http://prntscr.com/h283x5 , before only i edited here : /etc/phpmyadmin/apache.conf, but that did't worked for me..... – spylh9999ggr Oct 26 '17 at 10:44
@spylh9999ggr: Did you restart Apache after the change? – pa4080 Oct 26 '17 at 10:45
yes, i restarted..... – spylh9999ggr Oct 26 '17 at 10:45
@spylh9999ggr: How do you install phpmyadmin? Via apt or you've used some other method? – pa4080 Oct 26 '17 at 10:48
i used these commands : sudo apt-get update sudo apt-get install phpmyadmin php-mbstring php-gettext – spylh9999ggr Oct 26 '17 at 10:49
@spylh9999ggr: Maybe you have another directive related to phpmyadmin somewhere within your configuration - apache2.conf or /etc/apache2/sites-enabled/*.conf - that makes mess. Is phpmyadmin.conf exist in the directory /etc/apache2/conf-enabled/? – pa4080 Oct 26 '17 at 10:54
there is no phpmyadmin directory in path : /etc/apache2/conf-enabled – spylh9999ggr Oct 26 '17 at 10:56
also i have directory 000-default.conf under /etc/apache2/sites-enabled – spylh9999ggr Oct 26 '17 at 10:56
Let us continue this discussion in chat. – spylh9999ggr Oct 26 '17 at 11:00

change phpmyadmin url through /etc/apache2/conf-available.phpmyadmin.conf

1 Answers1

Linked