[GitHub] [incubator-shardingsphere] ICanFlyFaraway commented on issue #4377: sharding-proxy have been started, but the schema 'sharding_db' can not be seen in the navicat

[GitBox <gi...@apache.org>]

ICanFlyFaraway commented on issue #4377: sharding-proxy have been started,but the schema 'sharding_db' can not be seen in the navicat
URL: https://github.com/apache/incubator-shardingsphere/issues/4377#issuecomment-588666983
 
 
   i just use the example config like follow  
   
   #3697 config-sharding.yaml
   schemaName: sharding_db
   
   dataSources:
     ds0: 
       url: jdbc:mysql://localhost:3306/ds0
       username: root
       password: root
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 65
     ds1:
       url: jdbc:postgresql://localhost:3306/ds1
       username: root
       password: root
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 65
   
   shardingRule:
     tables:
       t_order:
         actualDataNodes: ds${0..1}.t_order${0..1}
         databaseStrategy:
           inline:
             shardingColumn: user_id
             algorithmExpression: ds${user_id % 2}
         tableStrategy: 
           inline:
             shardingColumn: order_id
             algorithmExpression: t_order${order_id % 2}
         keyGenerator:
           type: SNOWFLAKE
           column: order_id
       t_order_item:
         actualDataNodes: ds${0..1}.t_order_item${0..1}
         databaseStrategy:
           inline:
             shardingColumn: user_id
             algorithmExpression: ds${user_id % 2}
         tableStrategy:
           inline:
             shardingColumn: order_id
             algorithmExpression: t_order_item${order_id % 2}
         keyGenerator:
           type: SNOWFLAKE
           column: order_item_id
     bindingTables:
       - t_order,t_order_item
     defaultTableStrategy:
       none:
   
   #server.yaml
   authentication:
     users:
       root:
         password: root
       sharding:
         password: sharding 
         authorizedSchemas: sharding_db

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services