In this post we are going to see how to set password in phpmyadmin i.e when any user opens phpmyadmin of your local pc then phpmyadmin should ask for enter login credentials to see databases and table.
So, to configure phpmyadmin follow the steps below:
Step 2: After this you will see some users are already configured in phpmyadmin where you have to click on edit privileges link of highlighted all three users i.e. 127.0.0.1, ::1, localhost
Step 3: On each edit privileges click you will below page where you have to set same password for all three users which you want after each changes click on "Go" button
Step 4: After password setting of these three users just try to refresh your phpmyadmin dashboard, you will get "access denied" error as given in below image.
Error #1045 – Access denied for user ‘root’@’locahost’ (using password: YES)
Step 5: By resolving this error we are ends up with our root password setting of your wampp phpmyadmin for resolving this open the "config.inc.php" file found in C:\wamp\apps\phpmyadmin4.1.x and look for /* Authentication type */ around line 28.
Set your password for the root account by entering it between the single quotes ‘ ‘ in the following line:
$cfg['Servers'][$i]['password'] = 'mypassword';
$cfg['Servers'][$i]['password'] = 'mypassword';
Replace mypassword with your own password which you are configured in phpmyadmin
or for other option just comment
//$cfg['Servers'][$i]['auth_type'] = 'config';
& uncomment
$cfg['Servers'][$i]['auth_type'] = 'cookie';
Step 6: You are done with your setting for checking just open phpmyadmin in browser by following url: http://localhost/phpmyadmin/
You will see your phpmyadmin first page ask for username, password to enter in the phpmyadmin as below image
So, If you are having any query and doubt regarding this configuration then you can ask in comments.Thank you !!
No comments:
Post a Comment
If you have any doubts regarding the post. Please let me know.