Resetting Password

If you get 524 (HY000): Plugin 'auth_socket' Is Not Loaded type into MySql

update user set plugin="mysql_native_password";
flush privileges;