MySQL :Ignoring query to other database
遇見了一個低階的報錯,記下來:
[root@ZHANGLIN bin]# ./mysql -root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 87506
Server version: 5.6.19 Source distribution
Copyright (c) 2000, 2014, 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 databases;
Ignoring query to other database
mysql> use mysql;
Database changed
mysql> show tables;
Ignoring query to other database
mysql>
出現這個是因為登入MySQL的時候,沒有加上 'u' 也就是 -uroot 。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/30936525/viewspace-2016603/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL資料庫出現 Ignoring query to other databaseMySql資料庫Database
- Database | 淺談Query Optimization (1)Database
- Database | 淺談Query Optimization (2)Database
- flashback drop/query/table/database/archiveDatabaseHive
- How to release space from database( in other words: resize datafile ) (zt)Database
- How to release space from database( in other words: resize datafile ) 【zt】Database
- MySQL Query CacheMySql
- Mysql general query logMySql
- mysql 配置 General Query Log和# Slow Query LogMySql
- Query to Check SP/Table/Trigger Exists in Database or notDatabase
- MySQL Rewriter Query Rewrite PluginMySqlPlugin
- MySQL8.0:The General Query LogMySql
- create table of mysql databaseMySqlDatabase
- 關於mysql的query_cacheMySql
- proxysql mysql_query_rules 翻譯MySql
- ntpdate會導致mysql slow query log出現很大的query timeMySql
- 【Mysql】公開課之-Query-rewriteMySql
- Mysql 查詢快取 query_cacheMySql快取
- 利用tcpdump簡易抓取MySQL Query LogTCPMySql
- Runloop + runtime + otherOOP
- MySQL Slow Query log(慢查詢日誌)MySql
- 【MySQL】mysqldump Error 3024: Query execution was interruptedMySqlError
- MySQL slow query [慢查詢] 資料整理MySql
- MySQL效能剖析工具(pt-query-digest)MySql
- mysql database manual(mysql資料庫手冊)MySqlDatabase資料庫
- SQL SERVER恢復資料錯誤解決:The backup set holds a backup of a database other than the existingSQLServerDatabase
- PHP函式庫(other)PHP函式
- Other SGA Initialization Parameters (96)
- mysql 資料庫無法啟動Ignoring the redo log due to missing MLOG_CHECKPOINT betweenMySql資料庫
- Mysql mysql lost connection to server during query 問題解決方法MySqlServer
- mysql5.5_2013 Lost connection to Mysql server during queryMySqlServer
- Supported Platforms: MySQL Database MySQL安裝支援的平臺PlatformMySqlDatabase
- DZ論壇MySQL Query Error Errno:1046錯誤MySqlError
- MySQL - pt-query-digest的下載與使用MySql
- pt-query-digest分析mysql查詢日誌MySql
- mysql 必須掌握的工具pt-query-digestMySql
- read by other session等待事件Session事件
- Python class中的otherPython