Please help me with my installation of LAMP, this is my first time.
yesterday I installed Apache, PHP, and Mysql Flawlessly on my Ubuntu 16.04 LTS throught terminal. and the last thing I installed is PHPMYADMIN. After I installed it, I accidentally type my username "phpmyadmin" because Im a bit sleepy and confused and also I put some password on it. After that when I try to log-in and I to create a database, it says "No Privilege".
I also tried default "root" with and without password but cant login. so I tried to reinstall it, and also I tried to 'dpkg-reconfigure' but it give me some error message which has an option *abort, retry and etc. I also tried to purge remove all the phpmyadmin datas or files and also clear all my browsing histories aswell as my cookies. the last thing I tried is to use another and alternative database software which is 'Adminer'. after I installed the software, it didnt ask me for setup an admin account.
But when I about to use it. I cant login because I dont know what is my user? I tried 'root' with or without password but still cant login. but when I tried to log my account in phpmyadmin, I was surprised that it works and logged in. but unfortunately still cant create database and it has a dialogue like phpmyadmin : 'Access denied for user 'phpmyadmin'@'localhost'.
can someone help me through out this because, Im a bit frustrated and about to give up. :'(