136

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?

Somnath Muluk
  • 55,015
  • 38
  • 216
  • 226
mfs
  • 3,984
  • 6
  • 32
  • 51
  • 4
    i did. I searched alot. this is where i saw name root so many time. but they all where discussing some different issues and i never saw a single line "Try username = root and password is blank." anywhere until i posted it here – mfs Aug 02 '13 at 09:05
  • The 'root' is the administrator on Unix and Unix like operating systems. – Michas Nov 27 '13 at 12:10
  • https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html – Fr0zenFyr Sep 06 '19 at 05:59

7 Answers7

358

Try username = root and password is blank.

Tepken Vannkorn
  • 9,648
  • 14
  • 61
  • 86
  • 1
    You can also add to your **/etc/phpmyadmin/config.inc.php** file this line: $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; – Castiblanco Oct 30 '13 at 16:44
  • Hi, it will login into phpmyadmin, but not logged in adminer which is provided by wamp server. Have you any idea?? Thanks! – Hiren Gohel Nov 13 '18 at 13:39
32
http://localhost/phpmyadmin

Username: root

Password:

(No password set)

Companjo
  • 1,789
  • 18
  • 24
15

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.

Thea OK
  • 3
  • 1
Somnath Muluk
  • 55,015
  • 38
  • 216
  • 226
2
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/

Petter Friberg
  • 21,252
  • 9
  • 60
  • 109
AceRam
  • 279
  • 3
  • 6
0

In my case it was 

username : root
password : mysql

Using : Wamp server 3.1.0

Monster Brain
  • 1,950
  • 18
  • 28
0

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>
mLstudent33
  • 1,033
  • 3
  • 14
  • 32
0

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

Abidstic
  • 46
  • 4