In this article, we will find the solution for “MySQL Ignoring query to other database”,
Cause and Resolution:
Cause:
I keep on getting this weird message, while executing any query in command prompt MySQL. I have tried to changing to all databases in my MySQL server. But error remains same.
Reason: I had missed the “u” flag for user so accidentally I had input the following command.
mysql -root -p
Solution:
Connect to MySQL Server with all flags as shown below. Then, error gone.
mysql -u root -p
So, from the above solution u is missing flag while connected to MySQL Server.