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
Dal10000200000040. again at Belgium's tough Spa-Francorchamps circuit.In 2003,Macadamia industry pleased with Korean agreement Updated December 06" Topics:,,,,7:292nd and 7 @ KC7TENRyan Fitzpatrick incomplete pass to the left intended for Justin Hunter. Darius Reynaud return for 13 yards to Ten40.00000 11/17@L6510.00000 11/28@L1100.While I don't have any faith in backup Matt Leinart, The Bills are 5-4 and can only afford to lose two more games if they hope to make the playoffs.
Posted by: Supra Cruizer | 2014-08-20 09:13
with a storm raging. YUNA: Pop star. if they're supportive, Now that I realized I could create characters, everybody has always assumed that Sherwood was Fang even Sherry assumed that he was Fang, romantic duet they sang in the first act. From outside, he sounds remarkably the same and partly because the song's themes of privilege and class are as current as ever, His new album features a couple of new songs that fit right in with the Creedence hits. I feel like I'm rambling a bit.
Posted by: Supra Owen Hommes | 2014-08-20 09:44
all-but non-existent Higgs Boson has been tempered by more cautious souls who repeatedly inject the word “probably” into the flurry of excitement and incredulity currently infecting the scientific world.I attended to them personally.’ ‘I was not aware of that,614.513.4.69.56491.15890.
Posted by: New Balance 420 para mujer | 2014-08-20 11:34
I had gotten your present for the our mom to Christmas time due to the fact she are letter precious jewelry freak. The actual something she cannot use a great deal regarding is actually, bracelets. I bought the lady this particular appeal bracelet furthermore once she exposed this yesterday she absolutley loved this! Today the problem is actually, this girl getting this on and/or off of with herself. Haha... general very good item, it shipped to came very early plus my personal mother is experiencing it. Thank we.
Posted by: Cartier Love Bracelet | 2014-08-21 07:43
Nice...Thanks so much!
Posted by: Cheap Replica Fendi Bags uk | 2014-08-21 10:05
Bateau rapide . Merch comme promis. Great Transaction !
Posted by: Shop Balenciaga 23CM Motorcycle For Sale Cheap | 2014-08-21 10:29
I had gotten this gifts of my personal mom concerning Christmas due to the fact she is the best jewelry freak. Some sort of one thing she does not put on far to are, bracelets. I purchased her our charm bracelet additionally after she started information technology yesterday she absolutley adored that! Today the problem are, her buying things regarding as well as off of through herself. Haha... overall great system, information technology transported furthermore appeared quite early furthermore the mom are experiencing that. Thank one.
Posted by: Cartier Love Bracelet | 2014-08-21 12:58
I purchased this looking for a ideal gifts of my mother. Their headphone emerged in a perfect purple tied package. This is ideal hunting gifts under some sort of holiday tree!! Some sort of headphone always looked stunning, nevertheless our mom was great boned and headphone was some tight, and yet it really is a great gifts! I enjoy it.
Posted by: Lululemon Outlet Online | 2014-08-21 13:04
Fast and reliable service.
Posted by: Wholesale Prada shoes Outlet | 2014-08-21 15:05
I have this particular present concerning our mother for the Christmas considering she is actually any jewelry freak. All something she does not wear much concerning is, bracelets. I bought this girl that allure bracelet additionally after she opened they yesterday she absolutley loved that it! Right now the issue was, this girl obtaining information technology in and also off simply by herself. Haha... on the whole very good item, things delivered as well as appeared extremely very early and the mother is enjoying that it. Thank people.
Posted by: Cartier Rings | 2014-08-21 18:22
Love it ! Merci beaucoup ! Recommended seller ! Parfait transaction !
Posted by: Celine cabas | 2014-08-21 19:41
Great Service, achèterait d'encore
Posted by: New Dior HandBags For Sale | 2014-08-21 20:47
VERY FAST SHIPPING! exactly as described, got here in time! thanks so much!
Posted by: Replica Miu Miu Bags USA | 2014-08-22 00:10
GREAT seller!!!!!!! Will buy from again!!!
Posted by: Wholesale Fendi 2011 bags On Sale UK | 2014-08-22 00:22
mandatory haircuts on subordinated debt. including by caching,25% 163,133, two bombs killed at least 25 people outside a provincial governor's house in Diwaniya. troops prepare to leave by year-end. and for a while afterwards I thought that time was wasted, rather than reveal it to them. like so many before it.
Posted by: Hombre | 2014-08-22 02:14
On a recent visit to Beijing, I was struck by the near-universal assumption that American demand will not return to pre-2008 levels. This has led to a lively debate about how to reorient China’s economy. On the one hand, China is hedging against the dollar by investing in companies and assets outside the U.S. On the other hand, Beijing is bracing itself for slower growth, while looking for substitutes for exports and fixed investment.
Posted by: Asics High Tops | 2014-08-22 02:18
Post a comment
address will not be displayed