Authorization

    ShardingSphere-Proxy uses to configure user and authorization information.

    • ALL_PERMITTED: grant all authorities by default without authentication.
    • DATABASE_PERMITTED: grant users the authority to specify a logical database, mapped through user-database-mappings.

    The administrator can choose which privilege provider to use as needed when configuring authority.

    • The user root can connect to Proxy only through , and the password is root.
    • The privilege type is ALL_PERMITTED, which indicates that users are granted all authorities by default without authentication.

    DATABASE_PERMITTED

    The above configuration indicates:

    • The type is DATABASE_PERMITTED, which indicates that users are granted database-level authority and configuration is needed.
    • The user root can connect to Proxy only through localhost and can access sharding_db and test_db.
    • The user can connect to Proxy through any host and can access sharding_db.