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

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

run as sudo:

echo "/usr/sbin/mysqld { }" > /etc/apparmor.d/usr.sbin.mysqld
apparmor_parser -v -R /etc/apparmor.d/usr.sbin.mysqld
systemctl restart mariadb