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 6.2k times
77
Maik Lowrey
- 15,957
- 6
- 40
- 79
Mohd Abdul Mujib
- 13,071
- 8
- 64
- 88
1 Answers
187
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
- 13,071
- 8
- 64
- 88
-
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
-
3Apparently the same problem exists when you use `-U` instead of `-u`. – lmat - Reinstate Monica Aug 11 '20 at 17:56