I have done a fresh installation of Fedora 14 and installed the phpMyAdmin module. When I run phpMyAdmin, it asks me for a username and password.
What is the default username and password for phpMyAdmin?
Asked
Active
Viewed 1.1M times
194
-
13default database username: root and the password is empty... so Username:root , Password: – Karthik Apr 28 '11 at 12:12
-
Also try username: root and password: root if AllowNoPassword condition is set. – Adnan Khan May 22 '13 at 06:39
-
I just install PHPMyadmin And default username was diffren – Salem Dec 11 '14 at 11:40
-
4I Just install PHPMyadmin and default Username was phpmyadmin and password was asked during install .. as well you cane use MySQL root user and password to login – Salem Dec 11 '14 at 11:44
-
I am using mamp and I've seen commonly it has a default of Username : "root" and Password : "root" – Black Mamba Jul 15 '17 at 08:52
4 Answers
168
Default is:
Username: root
Password: [null]
The Password is set to 'password' in some versions.
Qarib Haider
- 4,796
- 5
- 27
- 38
-
For newer version, this is the username password but would only work when @KarmicDice's solution of updating to AllowNoPassword is done – pal4life Aug 15 '13 at 14:58
-
6In Version 4.0.6 Default username is still : **root** But default password is changed to : **password** – ram Sep 16 '13 at 08:34
-
2
-
4
-
2didn't work for version 4.4.11. neither root, not root:password, nor root:mysql – Valentin H Jul 12 '15 at 16:49
-
5This solution works if `AllowNoPassword` is true in config. Doesn't work for me – Adib Aroui Aug 04 '16 at 01:54
-
69
I just installed Fedora 16 (yea, I know it's old and not supported but, I had the CD burnt :) )
Anyway, coming to the solution, this is what I was required to do:
su -
gedit /etc/phpMyAdmin/config.inc.php
if not found... try phpmyadmin - all small caps.
gedit /etc/phpmyadmin/config.inc.php
Locate
$cfg['Servers'][$i]['AllowNoPassword']
and set it to:
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
Save it.
Keval Domadia
- 4,768
- 1
- 37
- 64
-
2Awesome fix. Here is the file location for ver phpMyAdmin-4.0.5 phpMyAdmin-4.0.5/libraries/config.default.php – pal4life Aug 15 '13 at 14:59
-
2Doesn't work for me. It's set correctly, and it makes sense, but phpMyAdmin is always coming back to me with "Login without password is forbidden". – Jay Versluis Feb 21 '14 at 00:29
-
3It's `/etc/phpmyadmin/config.inc.php` instead of `/etc/phpMyAdmin/config.inc.php` (all lower case) – a06e Dec 17 '15 at 19:27
-
Corrected @becko . Thanks. Next time feel free to edit it yourself :) – Keval Domadia Dec 25 '15 at 06:18
-
1For me the AllowNoPassword = TRUE; thing was already there, I just had to uncomment it. – Johannes Nov 03 '18 at 13:48
-
It did not solve this issue even after changing it to TRUE. What can be other option to change the password of phpmyadmin – Abhils May 23 '19 at 07:52
-
Change the password of phpmyadmin? AllowNoPassword is set to true when you use MySQL default installation which has no password. – Keval Domadia May 24 '19 at 08:10
57
This is asking for your MySQL username and password.
You should enter these details, which will default to "root" and "" (i.e.: nothing) if you've not specified a password.
JoshYates1980
- 3,476
- 2
- 36
- 57
John Parker
- 54,048
- 11
- 129
- 129
-
1That it for me, there was a dialog asking login password, but it was just login/password for MySQL – Nico Jan 27 '14 at 14:44
-
1This is the best answer, LOL on my intellegence :D +1 for your bang on answer :) – Ankur Verma May 15 '16 at 10:59
-
-
For security reasons it is password protected and only accessible when using 127.0.0.1 as the hostname – Tarun Oct 06 '16 at 16:01
