MySQL Error: Ignoring query to alternative database solution
Today login MySQL show databases appeared ignoring query to other database error, and tried several commands and SQL all prompt ignoring query to other database error
The error is as follows:
D:\Program Files\mysql\mysql Server 5.6\bin>mysql-root
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 66
Server version:5.6.15 MySQL Community Server (GPL)
Copyright (c) and/or, Oracle, its affiliates. All rights reserved.
Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.
Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.
mysql> show databases;
Ignoring query to other database
Mysql> Show tables;
Ignoring query to other database
Tossing for a long time only to find that the original is connected to MySQL without the "-U" parameter caused by
D:\Program Files\mysql\mysql Server 5.6\bin>mysql-uroot
Reconnect MySQL plus-u parameter everything is OK
MySQL Error: Ignoring query to alternative database solution