Re-Allowing 'root' access to PhpMyAdmin
It seems that in the newer verion of MySQL (or MariaDB) that the user 'root' may no longer connect to the database server via PhpMyAdmin (and other such tools). After searching the Interwebs and finding a few backwards and complicated solutions I found a better way, a simple way, very simple. In just 3 quick steps.
Step 1
Connect to the database server as root in a terminal and use the database 'mysql':
mysql -u root -p mysql
Step 2
Change the value of 'plugin' for the user 'root' in the table called 'users' to emtpy:
MariaDB [mysql]> update user set plugin='' where user='root';
Step 3
Flush priveles and you're good to go:
MariaDB [mysql]> flush privileges;
If you want to go back to disabling root access from anything other than the shell, you can follow the sames steps, but in step 2 change the 'plugin' value to "unix_socket":
update user set plugin='unix_socket' where user='root';