cant connect wordpress mysql. The server requested authentication method unknown to the client

hi , im trying DO managed databases and im facing some problem conencting it to my wordpress.

i read some on this community but i cant found the correct answer.

i have tried

ALTER USER 'MYUSER'@localhost IDENTIFIED WITH mysql_native_password BY 'MYPASSWORD'; and still cant connect.

i also tried https://www.digitalocean.com/community/tutorials/how-to-install-wordpress-managed-database-ubuntu-18-04

mysql version : mysql Ver 8.0.19 for Linux on x86_64 (MySQL Community Server - GPL)

this is how i create database and user

CREATE DATABASE MYDATABASES DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
CREATE USER 'MYUSER'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MYPASSWD';
CREATE USER 'MYUSER'@'server_public_ip' IDENTIFIED WITH mysql_native_password BY 'MYPASSWD';
CREATE USER 'MYUSER'@'server_private_ip' IDENTIFIED WITH mysql_native_password BY 'MYPASSWD';
GRANT ALL PRIVILEGES ON MYDATABASES.* TO 'MYUSER'@'server_private_ip';
GRANT ALL PRIVILEGES ON MYDATABASES.* TO 'MYUSER'@'server_public_ip';
GRANT ALL PRIVILEGES ON MYDATABASES.* TO 'MYUSER'@'localhost';

is there something that im missing ?