[GitHub] [shardingsphere] dengjin001 edited a comment on issue #12078: run sharding proxy succeed, but connect proxydb error

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

dengjin001 edited a comment on issue #12078:
URL: https://github.com/apache/shardingsphere/issues/12078#issuecomment-910270186


   > > Failed to initialize pool: Access denied for user 'root'@'127.0.0.1' to database 'sharding_db' at
   > 
   > Hi @dengjin001
   > The log showed that it's about privileges. Could you give it a check?
   
   i only start sharding-proxy, use mysql -client  connection,  mysql command show error.
   use navicat connection, although test connection is ok, but can't open this database.
   
   sharding -poxy service.yml  config:
   `governance:
    name: governance_ds
    registryCenter:
      type: ZooKeeper
      serverLists: localhost:2181
      props:
        retryIntervalMilliseconds: 500
        timeToLiveSeconds: 60
        maxRetries: 3
        operationTimeoutMilliseconds: 500
    overwrite: false
   
   scaling:
    blockQueueSize: 10000
    workerThread: 40
   
   rules:
    - !AUTHORITY
      users:
        - root@%:root
        - sharding@:sharding
      provider:
        type: NATIVE
   
   props:
    max-connections-size-per-query: 1
    executor-size: 16  # Infinite by default.
    proxy-frontend-flush-threshold: 128  # The default value is 128.
      # LOCAL: Proxy will run with LOCAL transaction.
      # XA: Proxy will run with XA transaction.
      # BASE: Proxy will run with B.A.S.E transaction.
    proxy-transaction-type: LOCAL
    xa-transaction-manager-type: Atomikos
    proxy-opentracing-enabled: false
    proxy-hint-enabled: false
    sql-show: true
    check-table-metadata-enabled: true
    lock-wait-timeout-milliseconds: 50000 # The maximum time to wait for a lock`
   
   ![image](https://user-images.githubusercontent.com/29300542/131676091-40d9e774-f90a-4bb2-bf3a-926cabdd661e.png)
   
   ![image](https://user-images.githubusercontent.com/29300542/131676967-844adaef-0851-4459-9d04-4939f4bc6b72.png)
   
   ![image](https://user-images.githubusercontent.com/29300542/131676807-fb96daa9-8672-425e-8d7e-ec8056269a24.png)
   


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org