RDS ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

Question

I set up my database 4 days ago, I realised something wrong with database when I tried to connect  it via my local computer. It wasn't connecting and giving error for no reason. So I looked to the error logs and saw this error:

"
[Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
"

It was fine until last night and all of a sudden today, even though I didnt changed anything I get this error. It looks like this error doesnt effect the working of my database but like I said I cant connect to the database in my mysql workbench because of this error also with this speed, logs are going to create huge amount of data that will impact on database performance.
I also looked if anyone had this issue there are plenty but there was no solution.

Accepted Answer

Actually I find out better solution then those two. For people who have the same issue follow this steps:

1- Open your rds instance page

2- Click "Actions" button at the top right.

3- Click "Set up ec2 connection"

4- Create your database - ec2 connection by following the steps that is showed up when you clicked

5- Connect to the instance that is connected with your database

6- If you are using linux as ec2 instance write this command,

mysql -h  -P  -u  -p

7- after executing this command mysql should be opened, run this query,

ALTER USER 'your_username'@'%' IDENTIFIED WITH caching_sha2_password BY 'your_new_password';

After this steps all of my problems I just mentioned solved.

Answer

> ⚡ This article might help you resolve the error [MySQL 8.0.34 Upgrade and tons of MY-013360 ‘mysql_native_password’ is deprecated warnings](https://www.brandonchecketts.com/archives/mysql-8-0-34-upgrade-and-tons-of-mysql_native_password-is-deprecated-warnings). A similar issue was addressed three months ago in this repost.aws article: [Getting rid of warning: plugin mysql_native_password reported 'mysql_native_password is deprecated'](https://repost.aws/questions/QUNe4_oNNuQQuB2pyBo8XGsw/getting-rid-of-warning-plugin-mysql-native-password-reported-mysql-native-password-is-deprecated).

RDS ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

相關內容