I am not a fan of using Phpmyadmin to run simple commands in mysql. Sometimes, things can be seen better using command line interface since they are less cluttered. So, here's how to login to mysql using command line. I assume you already have at least one database already constructed in MySQL.
Just run mysql -u USERNAME -pPASSWORD -h HOSTNAMEORIP DATABASENAME
Please note that there is no space between the argument / parameter -p and the password. So, if your mysql user is root, your password is iamgroot, your hostname is localhost and your database name is justadatabase, the command is: mysql -u root -piamgroot -h localhost justadatabase . Refer diagram below:
That's all. Please remember, when entering any command, include semicolon at the end as shown below: