解决linux系统mysql Ignoring query to other database问题

最新推荐文章于 2022-08-01 21:54:31 发布

请告诉他

最新推荐文章于 2022-08-01 21:54:31 发布

阅读量5.2k

点赞数 16

分类专栏： mysql 文章标签： mysql linux

本文链接：https://blog.csdn.net/fly19920602/article/details/118469169

版权

mysql 专栏收录该内容

12 篇文章 1 订阅

订阅专栏

问题

mysql> show profiles
    -> ;
Ignoring query to other database
mysql> use mysql
Database changed
mysql> show profiles
    -> ;
Ignoring query to other database
mysql> show databases;
Ignoring query to other database
mysql> show tables;
Ignoring query to other database

原因：登录进去时候直接mysql -u登录名 -p密码（这样进去如下）,但是忘记输入u了

[root@iZuf6d4hz02h806guxevyqZ ~]# mysql -root -pK111c@2020 
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 101050
Server version: 5.7.32 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, 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>的命令行等待界面

但是就是你输入什么命令都是Ignoring query to other database

解决

exit ;回车退出mysql命令行，重新登录进去

先：

[root@iZuf6d4hz02h806guxevyqZ ~]# mysql -uroot -p

以上命令输入完成后回车进入密码等待输入的提示，如下

Enter password:

此时输入的字符不被显示，注意你键盘大小写

输入完成后回车进入

[root@iZuf6d4hz02h806guxevyqZ ~]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 101057
Server version: 5.7.32 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, 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>

此时输入


mysql> show databases;

显示以下

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ky_parking         |
| mysql              |
| performance_schema |
| smart_parking      |
| sys                |
+--------------------+
6 rows in set (0.02 sec)

mysql>