Xampp MySQL said Cannot connect invalid settings error | Phpmyadmin

Xampp MySQL said Cannot connect invalid settings error while accessing Phpmyadmin

MySQL said:

Cannot connect: invalid settings.
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

1.Goto local-disk (c) - Xampp - Phpmyadmin
3.Goto the below line
/* Authentication type and info */
$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'] = '';
4.Change the settings from 'config' to 'http' on the line $cfg['Servers'][$i]['auth_type'] = 'config';
5. Now set any name for the the line $cfg['Servers'][$i]['password'] = '';
Example:- $cfg['Servers'][$i]['password'] = 'test';
7.Now load your web-browser
8.A box will pop-up asking for Authentication using username and password
Type the username as “root” password as “test”
9.That's it

[maryannfalceso]

please help, I follow all your steps but still did'nt work, the box keep poping up and asking username and password even though I entered correct username and password

[mehranmehrnia]

I have username='root' and password='test', but when I test my login does not accept please help.I have done all these things step by step

[khaledmetwaly]

حبييب البي وكتاب الله من غيرك مكنتش هشغله لو ايه
تسلم يانجم <3

[safiranira]

Thank you very much, this video is really helpful .. I've been searching for 2 hour to solved the problem and finally found this video.

[professorx]

I had to reboot the server but it worked. Thank you.

[nikhildhyani]

Thanks! I followed your procedure but when I changed the config to HTTP it didn't work, then I undid the changes i.e HTTP to config and removed the password and voila. It worked!

[jcuadrado]

Thank you so much for this, you saved my ass.
you my friend won a subscriber.

[iSunner]

god damn this's the one that solved my problem phew! thanks man

[Damien]

Thanks mate. just finished reinstalling this then got the prompt about setting a password for the root user, so i did. Then got the error. cheers for the fix :)

[mohsin]

Nice . its helped half of my problem. But it still rejects my username and password. And You are replying to all "thanks"- type comments only. what about those who has unsolved problem?

[RolliePollie]

For those not having success with the 'root' 'test' password pair; if you already have MySQL installed and you have a username and password set there try using that username and password. This is what worked for me. (cue facepalm)

[bajadudek]

Thank you very much. You save my final assignment

[bernardviernes]

it helps me a lot.. i love this tutorial.

[natouchouboire]

merci beaucoup !!!
tu m'a sauvé :*

[luisrios]

i did what you say but i still cant connect. i put the user "root" and my password but after i do it. it tells me that the username or password is incorrect so the acces is denied. NEED HELP ASAP

[manmrji]

Sir I'm getting below error while opening PHP Myadmin

Cannot connect: invalid settings.


MySQL said: Documentation

Cannot connect: invalid settings.
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]


mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client


Connection for controluser as defined in your configuration failed.


mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]


mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client


phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

[johnphillipninal]

still not working for me its just diplays blank page im suffering this for weeks then i cant still solve this help i cant start my activity becs of this problem

[nana]

Thank you so much, this video really helped me <3

[sweetooth]

Hey, I was having this problem so i restarted my computer and then restarted the desktop server and it let me go in the database. Sometimes it can be that simple, btw i tried everything you said to do and nothing worked so i reset everything back to normal and did the restart! Hope it helps someone

[ihsanharddy]

Thanks man its work c:, it help me alot