Root access to phpmyadmin was working, so i logged in as root to phpmyadmin and used the query set password for 'phpmyadmin'@'localhost' = password([copy and paste the password here]) and it worked! The phpmyadmin setup script is buggy on ubuntu and doesn't load the existing configuration (forcing you to start from scratch each time you configure it) It depends on your configuration
datbitchava - YouTube
Follow the instruction below to reconfigure phpmyadmin, and reset mysql password
Unix socket name of the database's administrative user
Root password of the database's administrative user Mysqlsamplepassword mysql username for phpmyadmin. I installed php, mysql, phpmyadmin on my ubuntu 12.04 localhost in the following steps I followed these steps on this site
Installing apache2 with php5 and mysql support on ubuntu | howtoforge so far my apache2, php, and mysql are working fine except phpmy. So, it is probably a port conflict You can also open server.xml in your lampp and change the port no Which would be different from that of xampp
Then both mysql (of xampp and lamp as well) will run.
Server 22.04 phpmyadmin localhost share improve this question edited aug 19, 2022 at 11:49 Alternatively, you could restrict phpmyadmin to only one specific port by creating a phpmyadmin version host and use the listen 99 directive to that virtual host. Cannot enter phpmyadmin as root (mysql 5.7) the answer is Root user can not log in at phpmyadmin interface, so root privileges must be given to another user (ex phpmyadmin user)
The actual answer that worked was not marked as correct on that page It was given by @hemamalini and it is Create user 'phpmyadmin'@'localhost' identified by 'some.
