clients, the client or proxy may have an er‐ ror prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 7.2. ShardingSphere-Proxy 16 Apache -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} Use the openGauss client to connect to the -P${proxy_port} -u${proxy_username} -p${proxy_password} Connect ShardingSphere‐Proxy with PostgreSQL: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} Connect ShardingSphere‐Proxy with openGauss

it.mysql.username=root it.mysql.password=root ## PostgreSQL configuration it.postgresql.host=db.psql it.postgresql.port=5432 it.postgresql.username=postgres it.postgresql.password=postgres ## SQLServer please refer to Quick Start. Using PostgreSQL 1. Use any PostgreSQL client end to connect, such as psql -U root -h 127.0.0.1 -p 3307. Using MySQL 1. Copy MySQL’s JDBC driver to folder ext-lib/. 2. Use /opt/shardingsphere‐proxy/ext‐lib. Access ShardingSphere-Proxy It is in the same way as connecting to PostgreSQL. psql -U ${your_user_name} -h ${your_host} -p 13308 FAQ Question 1: there is I/O exception (java.io.IOException)

information_schema、pg_catalog）支持有限，通过部分图形化 数据库客户端连接 Proxy 时，可能客户端或 Proxy 会有错误提示。可以使用命令行客户端（mysql、psql、 gsql 等）连接 Proxy 验证功能。 7.2.3 前提条件 使用 Docker 启动 ShardingSphere‐Proxy 无须额外依赖。使用二进制分发包启动 Proxy，需要环境具备 -P${proxy_port} -u${proxy_username} -p${proxy_password} 使用 PostgreSQL 客户端连接 ShardingSphere‐Proxy： psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} 使用 openGauss 客户端连接 ShardingSphere‐Proxy： -P${proxy_port} -u${proxy_username} -p${proxy_password} 使用 PostgreSQL 客户端连接 ShardingSphere‐Proxy： psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} 使用 openGauss 客户端连接 ShardingSphere‐Proxy：

information_schema、pg_catalog）支持有限，通过部分图形化 数据库客户端连接 Proxy 时，可能客户端或 Proxy 会有错误提示。可以使用命令行客户端（mysql、psql、 gsql 等）连接 Proxy 验证功能。 7.2.3 前提条件 使用 Docker 启动 ShardingSphere‐Proxy 无须额外依赖。使用二进制分发包启动 Proxy，需要环境具备 -P${proxy_port} -u${proxy_username} -p${proxy_password} 使用 PostgreSQL 客户端连接 ShardingSphere‐Proxy： psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} 使用 openGauss 客户端连接 ShardingSphere‐Proxy： -P${proxy_port} -u${proxy_username} -p${proxy_password} 使用 PostgreSQL 客户端连接 ShardingSphere‐Proxy： psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} 使用 openGauss 客户端连接 ShardingSphere‐Proxy：

clients, the client or proxy may have an er‐ ror prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 7.2. ShardingSphere-Proxy 16 Apache -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} Use the openGauss client to connect to the -P${proxy_port} -u${proxy_username} -p${proxy_password} Connect ShardingSphere‐Proxy with PostgreSQL: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} Connect ShardingSphere‐Proxy with openGauss

information_schema、pg_catalog）支持有限，通过部分图形化 数据库客户端连接 Proxy 时，可能客户端或 Proxy 会有错误提示。可以使用命令行客户端（mysql、psql、 gsql 等）连接 Proxy 验证功能。 7.2.3 前提条件 使用 Docker 启动 ShardingSphere‐Proxy 无须额外依赖。使用二进制分发包启动 Proxy，需要环境具备 -P${proxy_port} -u${proxy_username} -p${proxy_password} 使用 PostgreSQL 客户端连接 ShardingSphere‐Proxy： psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} 使用 openGauss 客户端连接 ShardingSphere‐Proxy： -P${proxy_port} -u${proxy_username} -p${proxy_password} 使用 PostgreSQL 客户端连接 ShardingSphere‐Proxy： psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} 使用 openGauss 客户端连接 ShardingSphere‐Proxy：

ShardingSphere document, v5.0.0 Using PostgreSQL 1. Use any PostgreSQL client end to connect, such as psql -U root -h 127.0.0.1 -p 3307. Using MySQL/openGauss 1. Copy MySQL/openGauss’s JDBC driver to folder /opt/shardingsphere‐proxy/ext‐lib. Access ShardingSphere-Proxy It is in the same way as connecting to PostgreSQL. psql -U ${your_user_name} -h ${your_host} -p 13308 FAQ Question 1: there is I/O exception (java.io.IOException) it.mysql.username=root it.mysql.password=root ## PostgreSQL configuration it.postgresql.host=db.psql it.postgresql.port=5432 it.postgresql.username=postgres it.postgresql.password=postgres ## SQLServer

Start. Using database protocol Using PostgreSQL 1. Use any PostgreSQL terminal to connect, such as psql -U root -h 127.0.0.1 -p 3307. Using MySQL 1. Copy MySQL’s JDBC driver to folder ext-lib/. 2. Use document, v5.1.1 Access ShardingSphere-Proxy It is in the same way as connecting to PostgreSQL. psql -U ${your_username} -h ${your_host} -p 13308 FAQ Question 1: there is I/O exception (java.io.IOException) it.mysql.username=root it.mysql.password=root ## PostgreSQL configuration it.postgresql.host=db.psql it.postgresql.port=5432 it.postgresql.username=postgres it.postgresql.password=postgres ## SQLServer

clients, the client or proxy may have an er‐ ror prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 2.2. ShardingSphere-Proxy 13 Apache -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} Use the openGauss client to connect to the -P${proxy_port} -u${proxy_username} -p${proxy_password} Connect ShardingSphere‐Proxy with PostgreSQL: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} Connect ShardingSphere‐Proxy with openGauss

clients, the client or proxy may have an er‐ ror prompt. You can use command‐line clients (mysql, psql, gsql, etc.) to connect to the Proxy’s authentication function. 2.2. ShardingSphere-Proxy 12 Apache -u${proxy_username} -p${proxy_password} Use the PostgreSQL client to connect to the ShardingSphere‐Proxy: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} Use the openGauss client to connect to the -P${proxy_port} -u${proxy_username} -p${proxy_password} Connect ShardingSphere‐Proxy with PostgreSQL: psql -h ${proxy_host} -p ${proxy_port} -U ${proxy_username} Connect ShardingSphere‐Proxy with openGauss