phpmyadmin root access denied

Last Thursday I upgraded to Ubuntu 9.04, and like always happens, sooner or later new (tiny/minor) problems arise from upgrades. Today I’ve found myself not being able to log into PHPMyAdmin with the root user, which has no password on my development machine, O_o

Looking around to find a solution to this problem (and after making sure root password was still the same using mysql console – that means empty password) I’ve found the solution.

Taking a look at the file  /var/www/phpmyadmin/libraries/config.default.php, line 345 in my machine, there was this code:
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;

Making AllowNoPasswordRoot be true, solves the problem:
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

I post this hoping somebody else could benefit from this ;)

Trackback URL

, ,

16 Comments on "phpmyadmin root access denied"

  1. Gabi
    28/04/2009 at 1:19 pm Permalink

    A mi sigue sin funcionarme…

    db_create.php: Missing parameter: new_db (FAQ 2.8)

    También funciona cambiando el modo autenticación de cookie a http… Pero da errores al importar, crear datos, crear en general cualquier cosa y demás… :S

    Saludos!

  2. Intru
    14/05/2009 at 4:33 am Permalink

    Thank you for this post, fixed my problem!

  3. Pau Sanchez
    15/05/2009 at 8:00 am Permalink

    @Intru You are welcome ;)

  4. Ricardo
    07/07/2009 at 1:06 pm Permalink

    Thanks, it also help me!

  5. glenn
    21/09/2011 at 12:55 am Permalink

    i want to create a website using joomla and i ‘m having a problem using the localhost supported my wamp.”db_create.php: Missing parameter: new_db (FAQ 2.8) appears when im creating new data base. i try to fix it and i cant..need help.thankx

Hi Stranger, leave a comment:

ALLOWED XHTML TAGS:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="" highlight="">

Subscribe to Comments