Shulou(Shulou.com)06/01 Report--

Mysql encounters an Ignoring query to other database problem:

Root@support ~] # mysql-root-p-socket=/tmp/mysql.sockEnter password: Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 5Server version: 5.6.22-log Source distributionCopyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql > show databases;Ignoring query to other databasemysql > show slave status\ GIgnoring query to other database-> Ctrl-C-- exited aborted

Ignoring query to other database

Puzzled, the cause of the error was found later. It is foolish that the user's name is missing-u.

Error: mysql-root-p-- socket=/tmp/mysql.sock

Correct: mysql-uroot-p-- socket=/tmp/mysql.sock

[root@support] # mysql-uroot-p-- socket=/tmp/mysql.sockEnter password: Welcome to the MySQL monitor. Commands end with; or\ g.Your MySQL connection id is 6Server version: 5.6.22-log Source distributionCopyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.mysql > show databases +-+ | Database | +-+ | information_schema | | _ client | | mfi_appstore | | mfi_boss_admin | | mysql | | performance_schema | | test | +-+

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.