How to use “mysql_native_password” in MySQL?

I tried using the command

default-authentication-plugin=mysql_native_password

default-authentication-plugin=mysql_native_password

at startup, but it didn't work, and the database failed to start. Since I use Prisma ORM, I need

mysql_native_password

mysql_native_password

instead of

sha256 authentication

sha256 authentication

How to use “mysql_native_password” in MySQL? - Dokploy