Xampp MySQL said Cannot connect invalid settings error | Phpmyadmin

34
2



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://saesrpg.net/

Xem thêm bài viết khác: https://saesrpg.net/giai-tri/

34 comments

  1. Mary Ann Falceso 7 July, 2020 at 00:36 Reply

    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

  2. MAG'é Comm 7 July, 2020 at 00:36 Reply

    Just changing $cfg['Servers'][$i]['auth_type'] = 'config'; to $cfg['Servers'][$i]['auth_type'] = 'http'; also works fine whithout setting up any password

  3. Chandan Singh 7 July, 2020 at 00:36 Reply

    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.

  4. Safira Nira Yuma 7 July, 2020 at 00:36 Reply

    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.

  5. luis rios 7 July, 2020 at 00:36 Reply

    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

  6. Khaled Metwaly 7 July, 2020 at 00:36 Reply

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

  7. Assad Rajab 7 July, 2020 at 00:36 Reply

    hey man thank you for this awesome video but it keep tolloing me that its not correct username/password why ?

Leave a reply