Change caching_sha2_password to mysql_native_password on a DigitalOcean's Managed MySQL Database

As caching_sha2_password was introduced in MySQL 8.0, but the PHP has not implemented this yet, in order to be able to connect to MySQL 8 from a PHP script, you need to change your authentication method from caching_sha2_password to mysql_native_password.

This is a short demo on how to do that change and connect to a DigitalOcean Managed MySQL.

I use DigitalOcean for all of my demos, you can use the link below to get a free $100 credit and spin up your own Linux servers!

Follow me on:



Xem thêm bài viết khác:

Article Tags:
Article Categories:
Công Nghệ

Leave a Reply

Your email address will not be published. Required fields are marked *