MySQL showing ERROR 1524

If you’re seeing that error message it most likely means there is corruption in at least one of your MySQL tables. The exact cause seems to vary case to case, but it looks like you can get this resolved by running a mysql_upgrade, or resetting MySQL's root password. I’d recommend trying the upgrade first.

I’ve included some articles below that take a deeper dive into this issue and outline some solutions that should help get you back on track.

https://computingforgeeks.com/how-to-solve-error-1524-hy000-plugin-unix_socket-is-not-loaded-mysql-error-on-debian-ubuntu/

https://serverfault.com/questions/761001/mysql-authentification-plugin-is-not-loaded

https://jee-appy.blogspot.com/2016/10/plugin-not-loaded-mysql.html