Run "SELECT HOST, USER, plugin FROM mysql.user" on a mysql query file to check if plugin is "mysql_native_password". If it is something else, here's what you do:

1. use "SHOW STATUS" on a query file.

2. Check if "mysql_native_password" status is active. If is not, or does not exists, here's what you will do:

3. Run "INSTALL PLUGIN mysql_native_password SONAME 'authentication_mysql_native_password.dll'"; for windows and "INSTALL PLUGIN mysql_native_password SONAME 'authentication_mysql_native_password.so'" for linux/maxOs. I believe status will be set to active automatically. This if the plugin is not installed. In case if plugin is installed and you want to make it active, heres what you do:

4. For windows: open "my.ini" file (found in C:\ProgramData\MySQL\MySQL Server 8.0\my.ini in my case, but depends where you installed mysql. ProgramData is a hidden folder set by system default.)

5. Just under "[mysqld]" add this: mysql_native_password=ON. Don't forget to save the file.

For this to work, you need to restart the server for both scenarios.

6. Open "run".
7. Open "services.msc".
8. Find "MySQL84". This is in my case. MySQL version is 8.4 at the time being. Number match your MySQL version.
9. Stop and start the server.

Disclaimer: This is also my first time doing this. In my case, I had the plugin installed, but the status was disabled. I got the answers from chatgpt,it solved my problem, you can give a try.