问题描述，今天登陆mariadb时，发现任何sql语句不能执行，报以下错误
|
1
2
3
4
5
6
|
MariaDB [(none)]> show databases;
Ignoring query
to
other
database
MariaDB [(none)]> show tables;
Ignoring query
to
other
database
MariaDB [(none)]>
select
database
();
Ignoring query
to
other
database
|
折腾了好长时间才发现，原来是登陆mariadb时敲错了一个字母如下所示
|
1
2
3
4
5
6
7
8
9
10
11
12
|
[root@kvm opt]# mysql -rroot -p123456
Welcome
to
the MariaDB monitor. Commands
end
with
;
or
\g.
Your MariaDB
connection
id
is
10
Server version: 5.5.52-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab
and
others.
Type
'help;'
or
'\h'
for
help. Type
'\c'
to
clear the
current
input statement.
MariaDB [(none)]> show databases;
Ignoring query
to
other
database
MariaDB [(none)]> show tables;
Ignoring query
to
other
database
MariaDB [(none)]>
select
database
();
Ignoring query
to
other
database
|
误把"-u"敲成了"-r"，同志们敲命令一定要仔细啊，要不然都是泪啊。
本文转自 茁壮的小草 51CTO博客，原文链接：http://blog.51cto.com/wn2100/1963525，如需转载请自行联系原作者
