Alhamdullilah I finally managed to get it to work. It turns out the configuration file for /etc/apache2/conf.d/phpmyadmin.conf provided by falko is not compatible with the original configuration file in /etc/phpmyadmin/apache.conf
So the solution is this. Delete phpmyadmin.conf in /etc/apache2/conf.d/ and after that create symlink with /etc/phpmyadmin/apache.conf file.
ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf
Restart apache after that.
I get help from here: https://help.ubuntu.com/community/phpMyAdmin
Maybe if you get any problem during installation you could refer to ubuntu phpmyadmin setup.
Thanks falko. I really appreciate your effort.
Originally Posted by falko
Is this from your failed login?
What's in /etc/apache2/htdocs?
That's not my IP. Maybe someone just trying to scan my vps.
root@server1:~# cat /etc/apache2/htdocs
cat: /etc/apache2/htdocs: No such file or directory
Well there's no such thing of htdocs in apache2 directory.