Question: I get the the following error: "Ignoring query to other database" when running a mySql command in the command line. Eg. SELECT  * FROM users; or SHOW tables;

 

Answer: 

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

Correct example:

{codecitation class="brush: bash;"}mysql -uroot -ppassword{/codecitation}

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

{codecitation class="brush: bash;"}mysql -rroot -ppassword{/codecitation}