Entering a password for a user in PhpMyAdmin in Wamp

Question

How do you change the password for the root user in phpMyAdmin on the WAMP server? because I am locked out of phpMyAdmin, after changing the password incorrectly.

Answer 1

my config.inc.php file in the phpmyadmin folder. Change the username and password to the one you set for your database.

<?php /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type and info */ $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'enter_username_here'; $cfg['Servers'][$i]['password'] = 'enter_password_here'; $cfg['Servers'][$i]['AllowNoPasswordRoot'] = true; /* User for advanced features */ $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = ''; /* Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['history'] = 'pma_history'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; /* * End of servers configuration */ ?> 

Answer 2

In the phpmyadmin folder there is a config.inc.php file.

File Path - C: \ wamp \ apps \ phpmyadmin4.0.4

Change cookie 'auth_type' to 'config' or 'http'

$ cfg ['Servers'] [$ i] ['auth_type'] = 'cookie';

 $cfg['Servers'][$i]['auth_type'] = 'config'; 

or

 $cfg['Servers'][$i]['auth_type'] = 'http'; 

When you go to phpmyadmin, you will be asked to enter your username and password. It also protects external users from accessing your phpmyadmin application if you have a web server open to external connections.

Answer 3

Return to the default setting by completing the following step:

Instead

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

change it to:

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

in your config.inc.php file.

Do not provide a password and put the username as it was before, which means root .

eg.

 $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; 

This worked for me after I edited the config.inc.php file.

Answer 4

I have some problems with it and I fixed it using a different configuration variable

 $cfg['Servers'][$i]['AllowNoPassword'] = true; instead $cfg['Servers'][$i]['AllowNoPasswordRoot'] = true; 

maybe it will be useful for someone

Answer 5

Locate the PhpMyAdmin installation for the Documentation.txt file. This section describes how to create the config.inc.php file and how to configure the username and password.

Answer 6

It looks like the phpmyadmin username and password are stored in a different place (possibly in a custom configuration file) in WAMP or there is additional hashing or ... participation in this process.

So, to change the default password currently used, "config'-file", you can view " <host>/phpmyadmin/user_password.php " using your browser. You will be prompted to enter your mysql credentials, and then you can use the displayed form to change the saved password for the user you previously logged in to.

Answer 7

if you do not find the use of the password in the mysql -u root -p command line, it will ask for the password, it will be the default password that you enter when the installation starts. This will be your password to enter phpmyadmin