How to get phpmyadmin username and password

Question

I have intalled phpmyadmin recently in my system. Now I lost its username and password. I tried the below methods for login.

in etc/phpmyadmin/config.inc.php I activated the AllowNoPassword

$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

It means you have forgotten your root password, then read this post : http://stackoverflow.com/questions/10070401/mysql-root-password-forgotten — kmas, Oct 14 '14 at 07:14
I also lost the username. Is there any way to get the username also? — John Mathew, Oct 14 '14 at 07:17
Your username and password are located in `/etc/phpmyadmin/config-db.php` — Dos, Jul 04 '20 at 17:05

score 23 · Accepted Answer · answered Oct 14 '14 at 08:01

 Step 1:

    Locate phpMyAdmin installation path.

    Step 2:

    Open phpMyAdmin>config.inc.php in your favourite text editor.

    Step 3:

    $cfg['Servers'][$i]['auth_type'] = 'config';
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = '';
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['AllowNoPassword'] = true;
    $cfg['Lang'] = '';

geoandri · Answer 2 · 2014-10-14T08:22:44.780

5

Try changing the following lines with new values

$cfg['Servers'][$i]['user'] = 'NEW_USERNAME';
$cfg['Servers'][$i]['password'] = 'NEW_PASSWORD';

Updated due to the absence of the above lines in the config file

Stop the MySQL server

sudo service mysql stop

Start mysqld

sudo mysqld --skip-grant-tables &

Login to MySQL as root

mysql -u root mysql

Change MYSECRET with your new root password

UPDATE user SET Password=PASSWORD('MYSECRET') WHERE User='root'; FLUSH PRIVILEGES; exit;

Kill mysqld

sudo pkill mysqld

Start mysql

sudo service mysql start

Login to phpmyadmin as root with your new password

edited Oct 14 '14 at 08:22

answered Oct 14 '14 at 07:38

geoandri

2,360
2
15
28

There is no option in my config file for user and password. But there is option for control user $cfg['Servers'][$i]['controluser'] = 'root'; $cfg['Servers'][$i]['controlpass'] = 'root'; I changed the control user but it's not working – John Mathew Oct 14 '14 at 08:03
I think the absence of those lines show that you username is root and you 'll have to change the root password in mysql server. I will edit my answer. – geoandri Oct 14 '14 at 08:19
when I run the command sudo service mysql stop it shows the error sudo: /etc/sudoers.d is world writable stop: Unknown instance: is it because of the permission? – John Mathew Oct 14 '14 at 09:06
Yes this is a different problem. You should resolve this first.Check http://stackoverflow.com/questions/13951700/sudoers-is-world-writable-error – geoandri Oct 14 '14 at 09:24

score 5 · Answer 3 · answered Dec 23 '17 at 16:34

5

Try opening config-db.php, it's inside /etc/phpmyadmin. In my case, the user was phpmyadmin, and my password was correct. Maybe your problem is that you're using the usual 'root' username, and your password could be correct.

answered Dec 23 '17 at 16:34

Hanz Marín

51
1
2

I found it by these 2 commands on ubuntu 20.04 LTS: `cd /etc/phpmyadmin` `sudo vi config-db.php` – H.M Maruf Mar 29 '22 at 19:51
I simply looked in this file and used the $dbuser='phpmyadmin' as the username and $dbpass='mypwdwaslistedhere' as the password; – garydavenport73 Mar 12 '23 at 14:20

score 1 · Answer 4 · answered Oct 14 '14 at 07:17

1

If you don't remember your password, then run this command in the Shell:

mysqladmin.exe -u root password NewPassword

where 'NewPassword' is your new password.

answered Oct 14 '14 at 07:17

Vidhyut Pandya

1,605
1
14
27

3

I also lost the username. Is there any way to get the username also? – John Mathew Oct 14 '14 at 07:22

score -1 · Answer 5 · answered Jan 30 '18 at 19:34

-1

I had a problem with this. I didn't even create any passwords so I was confused. I googled it and I found out that I should just write root as username and than click GO. I hope it helps.

answered Jan 30 '18 at 19:34

Ana-Marija

19

3

This assumes your root user doesn't have a password, and doesn't answer the question. – noahnu Jan 30 '18 at 19:57

How to get phpmyadmin username and password

5 Answers5

Linked