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;
MariaDB hangs

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