Reputation: 4074
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?
Upvotes: 136
Views: 669231
Reputation: 1792
http://localhost/phpmyadmin
Username: root
Password: (No password set)
Upvotes: 33
Reputation: 66
Sometimes accessing php my admin from other servers such as UwAmp can create problems. If it navigates to a login page simply use
Username: root
Password: root
Upvotes: 0
Reputation: 1165
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>
Upvotes: 0
Reputation: 2119
In my case it was
username : root
password : mysql
Using : Wamp server 3.1.0
Upvotes: 0
Reputation: 279
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/
Upvotes: 2
Reputation: 57626
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.
Upvotes: 15