NeverStopLearning4Life Posted November 27, 2020 Report Share Posted November 27, 2020 CRUD with MySQLI and PHP Chapter 1 - Lesson 1 - 11/27/2020 After following along with Ben and coding the example and opening it in chrome ... I get the following warning ... Warning: mysqli::__construct(): The server requested authentication method unknown to the client [caching_sha2_password] in C:\MAMP\htdocs\connect-db-live.php on line 12Warning: mysqli::__construct(): (HY000/2054): The server requested authentication method unknown to the client in C:\MAMP\htdocs\connect-db-live.php on line 12 Here is a screenshot from VSCode ... I looked for a solution online and found a page on Stack Overflow describing a solution but I couldn't figure out how to incorporate their solution into my code. Any assistance would be greatly appreciated. Here is the screenshot from StackOverflow ... Michael mastertouch53@gmail.com / mastertouch88@yahoo.com Quote Link to comment Share on other sites More sharing options...
administrator Posted December 2, 2020 Report Share Posted December 2, 2020 Hi, Hmm ... the above from Stack, is telling you to create a user account with the noted permissions. So try creating a new user in MySQL with the above commands. Makes sense? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.