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
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