Authentication plugin 'caching_sha2_password' is not supported || MySQL Python connector[SOLVED]

Authentication plugin 'caching_sha2_password' is not supported || MySQL Python connector[SOLVED] .
How to solve this error with proper Steps

[anirudhpoddar]

Thank you very very much bhaiya
Aapne ekdam se problem solve kar dia.
Thanks a lot.

[jas-mwfo]

Thank you for the tutorial. Just had my issue solved

[vineethbattula]

WOH BHAI, Seen a lot and struggled for an hour. You just made my day

[Mr_Cap.]

You solved my problem, Thank you so much.
I was passing auth_plugin at some other place, and it was always showing error.

[pratimsaha]

Thank you very much sir. You solved my problem. I was struggling with it a lot

[AbrarAhmed-cvur]

bhai Bhot sukria yar bhot bhot Thanks Akhir ab cl gya 😅❤❤❤

[ShortsForrYouu]

Bro you are really awsome thnku so much ❤️

[HYPER-ENLIGHTENMENT]

Thanks very much sir, thanks very much

[shwetanavalkar]

thank you so much it finally works! :D

[ritishanarnolia]

Mai library management ka project bana rahi hu agar yeh likha hua jayega toh mai kya reason bataungi iska

[Maychifps]

MUCHAS GRACIAS JOVEN ME HA SALVADO LA VIDA

[harshmishra]

Thank you so much HARE KRISHNA HAR HAR MAHADEV