Ken's Tech Note

In the recent version of Ubuntu with MySQL / MariaDB, phpMyAdmin can no longer be used via "root". This is because MySQL is now default to use UNIX auth_socket plugin for login for "root". The solution is to set the root user to use mysql_native_password plugin again. $ sudo mysql - u root mysql > USE mysql ; mysql > UPDATE user SET plugin = 'mysql_native_password' WHERE User = 'root' ; mysql > FLUSH PRIVILEGES ; mysql > exit ; $ service mysql restart