Mohd Abdul Mujib
Mohd Abdul Mujib

Reputation: 13928

"Ignoring query to other database" Command line

I keep getting this weird message, while executing any query in command prompt MySQL.

ignoring query to other database

I have already tried changing the database by issuing the "use database_name" command.

Upvotes: 81

Views: 70686

Answers (1)

Mohd Abdul Mujib
Mohd Abdul Mujib

Reputation: 13928

Ok, It seems, I had missed the "u" flag for user so accidentally I had input the following command.

mysql -root -p // Faulty connection

Instead of ...

mysql -uroot -p // Correct connection

Notice the missing "u" from the Faulty connection.

Upvotes: 203

Related Questions