How to change root password for mysql and phpmyadmin

Posted by Jon on Ask Ubuntu See other posts from Ask Ubuntu or by Jon
Published on 2012-04-04T05:15:37Z Indexed on 2012/04/04 5:40 UTC
Read the original article Hit count: 262

Filed under:
|
|

I've set up mysql and phpmyadmin and chose not to set a password when installing hoping that once set up i could login with root and no password but i get the following error from phpmyadmin

Login without a password is forbidden by configuration (see AllowNoPassword)

I have previously moved the phpmyadmin folder to /var/www/

I have tried changing the following line

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

to

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

but still had no success, so i am wondering is there a way i can change the root passwords for both so i can access phpmyadmin and create databases.

Thanks

© Ask Ubuntu or respective owner

Related posts about password

Related posts about mysql