axzxs2001 opened a new issue #13840:
URL: https://github.com/apache/shardingsphere/issues/13840
## Bug Report
An error occurred while connecting to shardingsphere database 。
**1、Version**
sharadingsphere 5.0.0
.NET 6.0
**2、code**
```
using MySql.Data.MySqlClient;
var constrbuilder = new MySqlConnectionStringBuilder()
{
UserID = "root",
Password = "root",
Server = "127.0.0.1",
Port = 3307,
Database = "sharding_db",
ConnectionProtocol = MySqlConnectionProtocol.Tcp,
};
Console.WriteLine(constrbuilder.ConnectionString);
using var con = new MySqlConnection(constrbuilder.ConnectionString);
con.Open();
using var cmd = new MySqlCommand("select * from accounting", con);
using var dr = cmd.ExecuteReader();
while (dr.Read())
{
Console.WriteLine(dr.GetValue(0));
}
```
**2、Excetipon**
MySql.Data.MySqlClient.MySqlException:“This version of ShardingSphere-Proxy
doesn't yet support this SQL. 'You have an error in your SQL syntax'”
--
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]
