How to log in to phpMyAdmin with WAMP, what is the

Question

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?

Answer 1

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/

Answer 2

Try username = root and password is blank.

Answer 3

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.

Answer 4

http://localhost/phpmyadmin

Username: root

Password:

(No password set)

Answer 5

In my case it was

username : root
password : mysql

Using : Wamp server 3.1.0