What does the word "root" mean in phpMyAdmin?
Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where I set them. From where can I get my username and password to login to phpMyAdmin?
This question is related to
php
mysql
windows
phpmyadmin
passwords
mysql> SET PASSWORD for 'root'@'localhost' = password('yournewpassword');
Check this out... https://hsnyc.co/how-to-set-the-mysql-root-password-in-localhost-using-wamp/
In my case it was
username : root
password : mysql
Using : Wamp server 3.1.0
http://localhost/phpmyadmin
Username: root
Password:
(No password set)
Sometimes it doesn't get login with username = root and password, then you can change the default settings or the reset settings.
Open config.inc.php file in the phpmyadmin folder
Instead of
$cfg['Servers'][$i]['AllowNoPassword'] = false;
change it to:
$cfg['Servers'][$i]['AllowNoPassword'] = true;
Do not specify any password and put the user name as it was before, which means root.
E.g.
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
This worked for me after i had edited my config.inc.php file.
I installed Bitnami WAMP Stack 7.1.29-0 and it asked for a password during installation. In this case it was
username: root
password: <password set by you during install>
Source: Stackoverflow.com