title: ERROR 1146 (42S02): Table 't.test_0' doesn't exist comes out, but the table is in the table list
body: <p>I am a beginner of mysql. I installed the mysql 8.0.16. Then I log in with root, created a database. Then I tried to use Sequel pro to create a table. After I finished that, ERROR 1146 (42S02) Table 'securities_master.exchange' doesn't exist comes out. I tried many way to fix it, but nothing worked. I really don't know how to deal with it.</p>
  
  <p>Server version: 8.0.16 MySQL Community Server - GPL
  System: MacOS 10.14
  At first, I use homebrew to install mysql. Then the problem comes out.
  I tried to uninstall it and install with DMG.
  Then, I tried to type database name and table name with lowercase.
  I deleted the ib_logfile0 and ib_logfile1.
  I restarted the server.
  I have dropped the database and create again.
  They didn't work.</p>
  
  <p>'''</p>
  
  <pre><code>mysql&gt; show databases;
  +--------------------+
  | Database           |
  +--------------------+
  | information_schema |
  | mysql              |
  | performance_schema |
  | sys                |
  +--------------------+
  4 rows in set (0.00 sec)
  
  mysql&gt; create database t;
  Query OK, 1 row affected (0.01 sec)
  
  mysql&gt; use t;
  Database changed
  mysql&gt; CREATE TABLE ‘test’(
      -&gt; ‘id’ int(11) unsigned NOT NULL AUTO_INCREMENT, 
      -&gt; ‘name’ varchar(10) NOT NULL,
      -&gt; PRIMARY KEY (‘id’)
      -&gt; );
  Query OK, 0 rows affected (0.02 sec)
  
  mysql&gt; show tables;
  +-------------+
  | Tables_in_t |
  +-------------+
  | ‘test’      |
  +-------------+
  1 row in set (0.00 sec)
  
  mysql&gt; desc test;
  ERROR 1146 (42S02): Table 't.test' doesn't exist
  mysql&gt; use mysql;
  Reading table information for completion of table and column names
  You can turn off this feature to get a quicker startup with -A
  
  Database changed
  mysql&gt; show tables;
  +---------------------------+
  | Tables_in_mysql           |
  +---------------------------+
  | columns_priv              |
  | component                 |
  | db                        |
  | default_roles             |
  | engine_cost               |
  | func                      |
  | general_log               |
  | global_grants             |
  | gtid_executed             |
  | help_category             |
  | help_keyword              |
  | help_relation             |
  | help_topic                |
  | innodb_index_stats        |
  | innodb_table_stats        |
  | password_history          |
  | plugin                    |
  | procs_priv                |
  | proxies_priv              |
  | role_edges                |
  | server_cost               |
  | servers                   |
  | slave_master_info         |
  | slave_relay_log_info      |
  | slave_worker_info         |
  | slow_log                  |
  | tables_priv               |
  | time_zone                 |
  | time_zone_leap_second     |
  | time_zone_name            |
  | time_zone_transition      |
  | time_zone_transition_type |
  | user                      |
  +---------------------------+
  33 rows in set (0.00 sec)
  </code></pre>
  
  <p>'''</p>