mysql错误:Ignoring query to other database

avatar 2020年9月21日18:08:10 评论 1,068 次浏览

进入mysql使用命令的时候总是提示:Ignoring query to other database,mysql没有做任何修改,刚刚还使用好好的,怎么就突然这样了,而且还是正式的环境就查看个数据没有做其他的呀。郁闷,从新查看一下命令:

  1. [root@wulaoer ~]# mysql -root -p
  2. Enter password:
  3. Welcome to the MySQL monitor. Commands end with ; or \g.
  4. Your MySQL connection id is 18
  5. Server version: 5.6.49 MySQL Community Server (GPL)
  6.  
  7. Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
  8.  
  9. Oracle is a registered trademark of Oracle Corporation and/or its
  10. affiliates. Other names may be trademarks of their respective
  11. owners.
  12.  
  13. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  14.  
  15. mysql> show databases;
  16. Ignoring query to other database

原来我在敲命令的时候没有制定-u,意思就是用户。这个错误虽然不是什么大的错误,不过值得记一下。

avatar

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

滑动解锁才能提交