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

preview_player
Показать описание
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:

  1. Bobby Iliev
Рекомендации по теме
MySQL : caching 0:01:23

MySQL : caching sha2 password is not supported mysql

How to fix 0:02:55

How to fix Authentication plugin 'caching_sha2_password' is not supported error?

Change Authentication Plugin 0:01:42

Change Authentication Plugin Method in MySQL

Error caching_sha2 _password 0:03:58

Error caching_sha2 _password python & mysql database connectivity

Authentication plugin 'caching_sha2_password' 0:03:10

Authentication plugin 'caching_sha2_password' is not supported || MySQL Python connector[S...

Change caching_sha2_password to 0:04:16

Change caching_sha2_password to mysql_native_password on a DigitalOcean's Managed MySQL Databas...

Configure Mysql 8.0.30 0:04:23

Configure Mysql 8.0.30 on Linux Ubuntu 22.04 LTS [Full Demo] Latest 2023 | mysql_secure_installation

12 - Password 0:11:52

12 - Password Management in MySQL | MySQL DBA Tutorial | MySQL 8 DBA Tutorial

MySQL 8 User 0:24:57

MySQL 8 User management | Copy password hash with caching_sha2_passwo | print_identified_with_as_hex

SQLyog MySQL 8.0.11 0:05:13

SQLyog MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be found !

Fix: MySQL Error 0:02:44

Fix: MySQL Error 1045 (28000) Access denied for user root localhost (using password YES) Windows 10

User creation in 0:36:06

User creation in MySQL | linux

MySQL Tutorial Part 0:20:48

MySQL Tutorial Part 7 Master Slave Database Upgrade

How to Install 0:02:45

How to Install MySQL 8 on Ubuntu 19.04

MYSQL INSTALL Ubuntu 0:03:44

MYSQL INSTALL Ubuntu with Password

Building Secure Applications 0:29:19

Building Secure Applications with MySQL Enterprise Edition

Drupal and MySQL 0:19:29

Drupal and MySQL 8.0 in OCI

Authentication Plugin 'caching_sha2_password' 0:02:16

Authentication Plugin 'caching_sha2_password' Cannot Be Loaded [MySQL Resolvido]

DataOps Barcelona Running 0:42:12

DataOps Barcelona Running MySQL & MariaDB Server securely in 2019

MySQL Upgrade Checker 0:35:45

MySQL Upgrade Checker | MySQL Upgrade | Percona server 5.7 to 8.0.27 | MySQL Shell utility | Percona

Upgrading to MySQL 0:22:30

Upgrading to MySQL 8 0+, a more automated experience by Nisha Gopalakrishnan

Script de Instalação 0:06:56

Script de Instalação Fácil em Sistemas Debian 9

Instalação da Versão 0:09:06

Instalação da Versão 4 4 via pacotes no Ubuntu Server com MySQL 8

Pen testing Opensource 0:58:39

Pen testing Opensource Databases MySQL and PostgreSQL — AWS

Комментарии
Автор

Note: DigitalOcean now offers a way to make that change directly via their Control Panel
- Go to your Control Panel
- Then go to your managed database
- Click on Users
- Then create a new user with the authentication method that you need

bobbyiliev_
Автор

One question, since I do not have access to copy that link drom 1:41 what should I do?

kazushisakuraba
Автор

After entering the password, command prompt shows (on windows)
plugin caching_sha2_password could not be loaded : Specified model could not be found. Library path is 'caching_sha2_password.dll'.
Please Help Me with this.

shreyakini
Автор

The default user that has the username `doadmin` does not have the privileges.
Did anyone encounter this issue?

MAHDYHAMADTheBeast
Автор

legit po ba ito caching sha 2 password po kasi palagi nakikita ko kahit my password naman nagawa po ? error po sya palagi caching sha2 password daw dapat ?

jovelynmae