taojintianxia opened a new issue, #22007:
URL: https://github.com/apache/shardingsphere/issues/22007

   Hi, there
   
   for some IDE or data transmation tool usage, it will read the data of tables 
in `information_schema`, and now the inforamtion_schema in ShardingSphere is an 
empty logical schema. please add a mapping from actual schema 
`information_schema` in MySQL.
   
   currently we have following steps to resolve this situation :
   ```
   use some_other_schema;
   
   drop database information_schema;
   
   create database information_schema;
   
   use information_schema;
   
   add resource ds_0 (
    
URL="jdbc:mysql://datasource-1.test:3306/information_schema?serverTimezone=UTC&useSSL=false",
    user=TEST_USER,
    password=PASSWORD,
    PROPERTIES("maximumPoolSize"=50,"idleTimeout"="6000")
   );
   ``` 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: 
[email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to