MySQL / MariaDB Enable Root Login

mysql -u root -p
update mysql.user set plugin='' where user='root';
flush privileges;