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

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:

mysql -uroot -ppassword

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

mysql -rroot -ppassword

• Add New Search
• Comments

• |2011-05-03 08:13:19 unknown
  try to open mysql in other command prompt
  • 0
  • 0

  ReplyQuote

• |2011-05-06 15:04:07 MySqluser - this also happened to me
  What I did I connected to mysql the following way
  
  mysql -Uuser -ppassword
  
  The I used a database that does not exists
  
  eg use nonExistent
  
  I got the error when I tried to show all tables. :-(
  
  I quit logged in using mysql -uroot -ppassword used the correct database and
  then it worked
  • 1
  • 0

  ReplyQuote

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.