Jeremy Davis's picture

But just in case I didn't (and/or someone else finds this thread looking for answers) I will post here.

You can log into phpMyAdmin with any valid MySQL user account (using the password of that account) - but you will only have the level of access that the MySQL user has. Because of that I personally like to use the MySQL root account (note this is not the Linux root user; which is used to log in to Webshell, SSH/SFTP and Webmin). If you need to reset the MySQL root account, you can do that with the firstboot script, which can be manually run with:

/usr/lib/inithooks/bin/mysqlconf.py