mfs
mfs

Reputation: 4074

How to log in to phpMyAdmin with WAMP, what is the username and password?

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

Answers (7)

Tepken Vannkorn
Tepken Vannkorn

Reputation: 9713

Try username = root and password is blank.

Upvotes: 362

Companjo
Companjo

Reputation: 1792

http://localhost/phpmyadmin
Username: root
Password: (No password set)

Upvotes: 33

Abidstic
Abidstic

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

mLstudent33
mLstudent33

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

Monster Brain
Monster Brain

Reputation: 2119

In my case it was

username : root
password : mysql

Using : Wamp server 3.1.0

Upvotes: 0

AceRam
AceRam

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

Somnath Muluk
Somnath Muluk

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

Related Questions