How do I access PHPMyAdmin in Ubuntu?

Question

I am trying to log into phpmyadmin however when I type username as "root" and password as blank, I get the error:

Login without a password is forbidden by configuration

I uncommented the line (in /etc/phpmyadmin/config.inc.php) :

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

but to no avail

Any help would be appreciated.

enter image description here

It would be worth checking you are accessing the right one. If you rename an index file in the same folder (assuming it is the vhost for the application itself), does your phpMyAdmin stop working? If not, you may have more than one installation. — halfer, Apr 08 '14 at 08:40
@ChristianMark It opens up to the login page :) I tried `root` and blank there. No use :) — An SO User, Apr 08 '14 at 08:41
Ahhh.. so you are trying to access MySQL thru your phpmyadmin? — Mark, Apr 08 '14 at 08:42
Ubuntu? Try to [reset your password](http://stackoverflow.com/questions/16556497/how-to-change-the-mysql-root-password/16556534#16556534) and see what happens. — Mark, Apr 08 '14 at 08:44
@ChristianMark Instead of blank, I must provide a password? :) — An SO User, Apr 08 '14 at 08:44
Wait, did you restart the mysql service in the terminal? the changes in your config file might still don't apply to your current MySQL/PHPmyAdmin — Mark, Apr 08 '14 at 08:47
@ChristianMark Done, sir ! Worked like a charm. Set the new password to 'root', too. Format this as an answer and I shall gladly accept it :) — An SO User, Apr 08 '14 at 08:47
You could be editing the wrong configuration. Try breaking the config purposely if it also breaks the page? — majidarif, Apr 08 '14 at 08:54

score 2 · Accepted Answer · answered Apr 08 '14 at 08:48

Try to reset your password in your MySQL like this:

Set / change / reset the MySQL root password on Ubuntu Linux. Enter the following lines in your terminal.

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;

Note: This method is not regarded as the securest way of resetting the password. However it works.

References:

1 Answers1