Error: "Ignoring query to other database" when running a mySql command in the command line

E.g. SELECT  * FROM users; or SHOW tables;

In the command line make sure you used the correct syntax when connecting to mySql

Correct example:

mysql -uroot -ppassword

Wrong example: (This is what I did that caused this error)

mysql -rroot -ppassword