ERROR 1146 (42S02)

培训中心 实战分享
#1

【产品名称】

【产品版本】

【问题描述】

ERROR 1146 (42S02): Table ‘oceanbase.__all_database’ doesn’t exist

#2

# obclient -h 127.0.0.1 -P 2883 -uroot

Welcome to the OceanBase. Commands end with ; or \g.

Your MySQL connection id is 3221225479

Server version: 5.7.25 OceanBase 3.1.0 (r-) (Built May 30 2021 11:21:29)


Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.


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


MySQL [(none)]> show databases;

ERROR 1146 (42S02): Table 'oceanbase.__all_database' doesn't exist

MySQL [(none)]>

1 个赞
#3

你i连接命令方式不对，集群自举完成后，2881连接本地用：mysql -h127.1 -uroot@sys -P2881 -p -c -A