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/ 

MySQL in ubuntu 18.04 (update)

It was a long time ago, I make a post (or my personal note) about how to install MySQL in ubuntu
and it seems now, the version and how to install is already changed so I make this post.

previous post here

Step:
0. apt get update (start with this)

sudo apt-get update

1. Installing MySQL

sudo apt-get install mysql-server

1.1. mysql secure installation (optional but recommended)

sudo mysql_secure_installation

2. Installing apache2

sudo apt-get install apache2

3. Installing phpmyadmin

sudo apt-get install phpmyadmin

4. connect apache2 and phpmyadmin

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf

5. activate it

sudo a2enconf phpmyadmin.conf

6. restart apache

sudo systemctl reload apache2.service

ok done