Ignoring query to other database问题的解决办法

时间:14-05-27 栏目:网络 作者:云中鹤 评论:6 点击: 2,693 次

今天在输入MYSQL命令时候,突然碰到Ignoring query to other database提示,尝试了好几个命令都是一样的Ignoring query to other database提示。仔细一看,发现登录的时候用户没有使用-u参数传递。

[root@localhost MHA-0.55-0.el6-P1.0.1-x86_64]# mysql -root -proot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.5.27-log MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

mysql> show master status;
Ignoring query to other database
Ignoring query to other database
mysql> show databases;
Ignoring query to other database
mysql>

手误的原因导致的错误,不细心害死人啊,不过这个-r参数是什么呢?欢迎知道的朋友告诉我,先谢过!

声明: 本文由( 云中鹤 )原创编译,转载请保留链接: Ignoring query to other database问题的解决办法

Ignoring query to other database问题的解决办法:目前有6 条留言

  1. 6楼
    EQ Next Plat:

    EQ Next Plat

    Hello, just wanted to mention, I loved this post. It was inspiring. Keep on!

    2014-06-26 上午4:51
  2. 5楼
    Lotro Power Leveling:

    Lotro Power Leveling

    Perfect Words. My thanks for doing such a nice report. I will return here to find out more and recommend my neighbors about your articles.

    2014-06-28 上午1:46
  3. 4楼
    烟雨网:

    自己顶下

    2014-07-03 上午11:24
  4. 地板
    网易好友:

    粗心大意惹的祸啊

    2014-07-03 上午11:34
  5. 板凳
    烟雨江南:

    路过,看看你

    2014-07-03 下午2:20
  6. 沙发
    烟雨江南:

    我的评论么发出来?

    2014-07-03 下午2:23

发表评论

您必须 [ 登录 ] 才能发表留言!