Change phpmyadmin's URL in ubuntu

A few years ago I put some note for windows here

and now I will make one for ubuntu

So for example, I want to change my phpmyadmin link

default: 127.0.0.1/phpmyadmin and I want to change it to 127.0.0.1/myownlink

we need to change 1 setting in apache2

sudo nano /etc/apache2/conf-enabled/phpmyadmin.conf

change the alias

Alias /phpmyadmin /usr/share/phpmyadmin

to

 Alias /myownlink /usr/share/phpmyadmin

then we need to activate and restart apache2 (maybe only restart apache2 will do it)

 sudo a2enconf phpmyadmin.conf

 sudo systemctl reload apache2.service

done yey \o/ 

Enable login in phpmyadmin

Now I want to enable login in my phpmyadmin

First change root password (both) using phpmyadmin
Then after you change it, it will send you an error message
Open this file

C:\xampp\phpMyAdmin\config.inc.php

Change the line 19

$cfg['Servers'][$i]['auth_type'] = 'config';

To

$cfg['Servers'][$i]['auth_type'] = 'cookie';

And also line 23

$cfg['Servers'][$i]['AllowNoPassword'] = true;

To

$cfg['Servers'][$i]['AllowNoPassword'] = false;

After that restart you apache
Done

 

Change phpmyadmin's URL in XAMPP windows

I just setting my phpmyadmin in windows

I installed it using XAMPP

And I want to change the phpmyadmin's URL

default: 127.0.0.1/phpmyadmin and I want to change it to 127.0.0.1/myownlink

It's not hard

just open this file

C:\xampp\apache\conf\extra\httpd-xampp.conf

 In line 99

Alias /phpmyadmin "C:/xampp/phpMyAdmin/"

Change it to

 Alias /myownlink "C:/xampp/phpMyAdmin/"

And don't forget to restart your apache in XAMPP
Done