How can I connect with command line to MySQL on Linux?
Quick solution, just enter:
mysql -u root -p
It will ask you for password. In case you want to login on any other user, instead of 'root' use other user name.
If we want to enter password in the same line:
mysql -u root -proot
Parameter -p is connected with our password in this case the password is root.
When we use MySQL or MariaDB for tests on localhost or VM's we use root or admin as a password, for convenience when the security is not so importnat.