Xampp MySQL said Cannot connect invalid settings error while accessing Phpmyadmin
Website :-
When you tried to access [Phpmyadmin] on your localhost [Xampp installation] you may encounter the below error due to changes in the user privileges.You should be careful when dealing with the password of users.
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
2.Open Config.inc.php
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’;
6.Save the Config.inc.php file
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
Facebook :-
Blog:-
Pinterest:-
Tumblr:-
For a detail description visit:-
Please subscribe to my channel:-
Nguồn:https://danhnhan.vn/
Xem thêm Bài Viết:
- Điểm danh các gương mặt sáng giá trong đội hình MU FO3
- nhạc sống tuyển chọn cực hay-phong cảnh đẹp-không quảng cáo
- Thanh Xuân Nhất Định Phải Ghé Sapa Một Lần Trong Đời | Du Lịch Tây Bắc | Du Lịch SayHi
- Du lịch Sapa 2 ngày 3 đêm giá siêu rẻ (Hotline 0934507489)
- [Tây Bắc Vlogs] Cảnh Đẹp Hùng Vĩ Tây Bắc | Con người và lối sông văn mình đẹp đẽ vùng cao
https://danhnhan.vn/giai-tri
Xem thêm Bài Viết:
- Điểm danh các gương mặt sáng giá trong đội hình MU FO3
- nhạc sống tuyển chọn cực hay-phong cảnh đẹp-không quảng cáo
- Thanh Xuân Nhất Định Phải Ghé Sapa Một Lần Trong Đời | Du Lịch Tây Bắc | Du Lịch SayHi
- Du lịch Sapa 2 ngày 3 đêm giá siêu rẻ (Hotline 0934507489)
- [Tây Bắc Vlogs] Cảnh Đẹp Hùng Vĩ Tây Bắc | Con người và lối sông văn mình đẹp đẽ vùng cao
You are hero 😀
It does work. Thanks.
thanks
When i put in the username and pass it does not work
thanks sir
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
helped me, Thanks
whats the song ?
the password and user name is not working
Just changing $cfg['Servers'][$i]['auth_type'] = 'config'; to $cfg['Servers'][$i]['auth_type'] = 'http'; also works fine whithout setting up any password
Thank you 🙂
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.
still it's not opening
Indian bullshit
liar
Thank you for this video, it really helped.
thank youuuu <3
Thank u so much
It works:-)
god damn this's the one that solved my problem phew! thanks man
Excellent tutorial! Man, I can't stop jamming to this music. On my 4th time playing the video!
Thank you so much, this video really helped me <3
still not working need some help
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.
thank you!
thank you dude…..please forward me your social account username ..i want to follow you
mine conf.inc.php is a read only file
what about the same problem in linux??
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
Thank You VM
Thank you so much for this, you saved my ass.
you my friend won a subscriber.
Thank you body! 🙂
Thank you very much. You save my final assignment
Thanks
thank you sooo much:)
حبييب البي وكتاب الله من غيرك مكنتش هشغله لو ايه
تسلم يانجم <3
hey man thank you for this awesome video but it keep tolloing me that its not correct username/password why ?
thank you so much