October 19, 2011

MySQL | "Ignoring query to other database"

A bit of a gotcha maybe, especially if you're used to the PostgreSQL CLI (where -U specifies the user name):

[user@example.com]# mysql -Uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.41-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database some_database;
Ignoring query to other database
mysql> show databases;
Ignoring query to other database
mysql> Bye

Although the connection to MySQL was seemingly successful, any commands only seem to result in the laconic message "Ignoring query to other database". I'm not quite sure why this happens, but -U has the following meaning in MySQL:

  -U, --safe-updates  Only allow UPDATE and DELETE that uses keys.
  -U, --i-am-a-dummy  Synonym for option --safe-updates, -U.

Once again a bit of a head-scratcher which would be helped at the very least by less ambiguous notification messages.

Posted at 1:19 AM

There is a syntax error in the command :-
#mysql -Uroot -p

Instead of -U, please use -u (small letters)
So the command will be :-
#mysql -uroot -p

It will resolve your concern
Posted by: Rajnesh Siwal | 2011-10-30 20:11
Thank you, but I'm aware there's an "error" - it's the way MySQL make it very unclear what has happened which is causing me to complain.
Posted by: Ian Barwick | 2011-10-30 20:35
Super fast shipping! Great seller! Item exactly as described!! Thanks!!!!
Posted by: New Belts Bags For Sale | 2014-10-24 19:07
A+++ seller with fast shipping! Very pleased!
Posted by: Fake Roger Vivier Handbags Outlet Store | 2014-10-24 21:00
sThe grade this awesome, however, due some sort of dimensions operate mini take that it single dimensions increase.If you're 5f 4inches subsequently size demands modifying otherwise only don really tall footwear. Other than that loved ones gown
Posted by: Cheap dr dre headphones | 2014-10-24 22:35
Very pleased with purchase. Thank you! A++++++++++
Posted by: Discount Fendi Sunglasses For Sale | 2014-10-24 23:17
What a deal! Great seller, fast shipping! A++++
Mutsun et Chalone am茅rindienne GroupsThese deux groupes am茅rindiens de la c么te de la Californie vit dans le parc national Pinnacles depuis de nombreuses ann茅es, et des objets de leurs cultures ont 茅t茅 trouv茅s dans le parc. Acron meules sont especailly importante, puisque le parc offre de nombreux arbres qui portent des glands et de la farine de gland fait d'eux est assez bonne.
Posted by: prada montevarchi | 2014-10-25 04:30
”Lelaki ini banyak menolong Eizara sejak dari pertama kali mereka berkenalan.” Sengaja Eizara bersuara manja dengan Rayyan kerana dia sudah terbiasa. Dia rasa seperti rohnya turut ditarik bersama dengan sel darah merah Chesire. Namun akibat tidak dapat mengalahkan sihir avada kedavra yang sangat kuat, pasti Rozaimi fikir yang dia ingin mengelak. boleh juga,“Aku nak resign. Bila pula dia ni sampai kat belakang aku? Mata akan tertumpu pada Masjid Shah Alam yang boleh kelihatan dengan jelas dari sini.“Cepat la balik kolej.
Posted by: Picasso Short Ugg Boots | 2014-10-25 04:37
6bn) a year, education.
Posted by: Canada Goose Lodge Jakke | 2014-10-25 06:47
Item arrived promptly and in perfect condition. Great transaction. Thank you!
Posted by: Monogram Multicolore Wallets Copy Outlet | 2014-10-25 07:34
Fast shipping! Item as described. Thank you!
Posted by: Discount Alexander Mcqueen Sunglasses Online | 2014-10-25 08:24
”,“Hang Tuah pun dah carik girlfriend sendiri bang! Zue. kau saje je ni nak minta aku tolong bawa sebab bilik kau kat tingkat dua kan? nak dengar radio ke? Adham membalas senyuman Noli lantas terus sahaja membantu gadis itu menjawab persoalannya. beberapa minit kemudian,“I Love you to” Jawab ringkas Zila walaupaun dalam keadaan yang sedikit sukar. solat itu tiang agama, sejauh mana amal soleh.
Posted by: Women Timberland 6 Inch Boots | 2014-10-25 08:32
Kesian kau Idham, ‘Kenapalah mama tak faham ?“Hello mysweetheart??”Eh, Tidak betah berlama-lama bersama berhadapan dengan lelaki ini.” Tegas Ivy Melissa. Lantaran itu, Aku tahu,nak muntah bila teringat balik”Serious rasa nak muntah.” Aku nak sambung jadi nose to heart…boleh?
They are perfect, quick shipment. Love them.
Posted by: New 1095 Steel Samurai Sword For Cheap | 2014-10-25 08:53
Fast Shipping. Item as described.
Posted by: Tanto Swords | 2014-10-25 09:05
Just as described. Super quick shipping and well packed. Thank you
Posted by: Moose Knuckles Men Jackets UK Outlet | 2014-10-25 09:07
Passage after passage in the self-published book describes the boy Ajak’s days in the brush or jungle, dodging bullets, hearing others’ screams of torture,Michael Kors Bags, afraid to sleep for fear of being eaten by a wild animal, and walking, always walking, in search of safety. Even after reading the words on the page, it is impossible to imagine what he and other children endured.
Posted by: Womens Dakota | 2014-10-25 09:20
This seller shipped my item faster than any other. Phenominal seller!
Posted by: Discount Japanese Sword UK For Cheap | 2014-10-25 09:43
Ma l non ne vuole sapere di aiutare i lavoratori in questo e da qui le proteste delle migliaia di dipendenti di questi giorni, che vanno a sommarsi a quelle di tanti altri operai sparsi nel paese per questioni legate alle condizioni di lavoro e ai contratti.Anche i Panthers e le Starlight Cheerleaders andranno di corsa
Posted by: centro hogan palermo | 2014-10-25 09:45
Critics - chiefly o
Posted by: Half Jacket | 2014-10-25 10:58
Foul by Declan Gallagher (Dundee).
Posted by: Promotions | 2014-10-25 11:02
2011 March - Ethiopia accuses Eritrea of sending agents across the border to plant bombs and warns it will take all necessary measures to halt Eritrean "aggression".
Posted by: Kids Timberland Boots | 2014-10-25 11:26
Images seen by the BBC show men and women lying on the floor in pools of blood following the attack,Michael Kors.
Posted by: - New Balance 574 Dragon (3) | 2014-10-25 11:31
Jalal Salahuddin: Firstly, creativity, coupled with an incredible amount of energy and drive, a people friendly and outgoing attitude, out-of-the-box thinking and an ability to delegate and be a team leader. I would also add the ability to stay calm is important but this mostly bypasses me!
Posted by: UGG New 6802 | 2014-10-25 11:33
MR. BROOKS:? Obama has not done that.? He's not gone out with the pie charts and said, "Here's what we've got to do, people." And so they've got a deal, even if they come up with it, I doubt they'll be able to sell.? So I'm very pessimistic about what's going to happen here over the next couple of months. The second thing that makes me pessimistic is both sides think the political advantage is with them with going to the wall.
Posted by: Canada Goose Snow Mantra Parka | 2014-10-25 12:36
Exp茅dition rapide superbe ! Grande marchandises comme promis ! A + + + +
Posted by: Moose Knuckles Kids Jackets For Sale | 2014-10-25 12:36
Singapore To the great surprise of many of his followers, he decided.the melted remains of a TV, how do we come and sit together? Assisted by Christian Benteke. 65:17 Foul by Ciaran Clark (Aston Villa). "There's a reason it looks like a plastic bag - it is a plastic bag, "I think the issue is when you open the package they're already open - they're not like male condoms that are in these neat little packages and then they're unrolled, including the Twitter-like Sina Weibo. three arrests have been made in connection with the posting of offensive tweets. 21:18 Corner.
Posted by: Customer Service | 2014-10-25 14:03
"We made it clear to Mr Wallace that we felt it was also appropriate that they provide the same undertaking for Murray Park.
Posted by: Fitflop Sling | 2014-10-25 14:05
great service hope to deal with you again! LOVE IT!!!
Posted by: Fake Taiga Leather Wallets Wholesale | 2014-10-25 15:11
Excellent Service!! Fast Shipping!!!!!!!!!! A+++++++
Posted by: Moose Knuckles Women Jackets Sale | 2014-10-25 15:46
Quelle affaire ! Grand vendeur, exp茅dition rapide! A + + + +
Posted by: Cheap Moose Knuckles Men Jackets For Sale | 2014-10-25 16:11
JIMI IZRAEL: C-Headlee, how you doing?
Posted by: Canada Goose Snow Mantra Parka | 2014-10-25 17:16
Foul by Dylan McGowan (Hearts).
Posted by: Correa Acero | 2014-10-25 17:32
Post a comment
address will not be displayed