How To Deal With MySQL Ignoring Query To Other Database?

Asked By Rinku Anjus 0 points N/A Posted on - 07/02/2016

I am using MySQL to execute SQL queries to obtain data from multiple databases and I am continually getting this error MySQL ignoring query to other database. How to prevent this error?

• Status: Open
• Question Views: 1711
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Cindi Zhao 850 points N/A #90425

How To Deal With MySQL Ignoring Query To Other Database?

This is a very common error and all you need to do is add a suffix to the MySQL statement of -u to the statement. That is if your statement is in the format of #mysql-root -p then you should only change it to #mysql -u -root -p and the error will be totally rectified.

About Cindi Zhao

Questions
1

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/02/2016
• Question Category: MySQL Server