Jump to content

CRUD Basics - End of Lesson 1 - Error server requested authentication method unknown to the client


Recommended Posts

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 12

Warning: 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 ...

image.thumb.png.c16f96a94d2349effecc332ec4dbebbb.pngimage.thumb.png.35bd767adf2b20fc52bdb42bab6a7080.png

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 ...

image.thumb.png.2616cb877ec1fbf649f3c8f7cb178f8a.png

Michael

mastertouch53@gmail.com / mastertouch88@yahoo.com

 

 

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...