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.
Asked
Active
Viewed 5.3k times
69
Maik Lowrey
- 10,972
- 4
- 14
- 43
Mohd Abdul Mujib
- 11,978
- 8
- 59
- 84
1 Answers
168
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.
Mohd Abdul Mujib
- 11,978
- 8
- 59
- 84
-
4Using "mysql -u root -p" with a space after u brought me to this question :) – sr9yar Dec 11 '16 at 13:17
-
4@sr9yar I think, the whitespace after `-u` flag should'nt be a problem. Are you sure *that* was the issue? as discussed here http://stackoverflow.com/questions/39636160/mysql-connection-whitespace-after-user-flag – Mohd Abdul Mujib Dec 12 '16 at 05:55
-
1yes its true. the space has no issue. you either use -uroot or -u root – mehmoodnisar125 Dec 11 '18 at 10:48
-
1You're awesome! – Aluthren Sep 27 '19 at 23:23
-
3Apparently the same problem exists when you use `-U` instead of `-u`. – lmat - Reinstate Monica Aug 11 '20 at 17:56
-
Awesome Problem :)))) – Ebrahim Bashirpour May 13 '22 at 11:34