I keep getting this weird message, while executing any query in command prompt <code>MySQL</code>. <pre class="prettyprint"><code>ignoring query to other database </code></pre> I have already tried changing the database by issuing the <code>"use database_name"</code> command.

Ok, It seems, I had missed the "u" flag for user so accidentally I had input the following command. <pre class="prettyprint"><code>mysql -root -p // Faulty connection </code></pre> Instead of ... <pre class="prettyprint"><code>mysql -uroot -p // Correct connection </code></pre> Notice the missing "u" from the Faulty connection.