一 、下载jdbc 驱动
http://central.maven.org/maven2/mysql/mysql-connector-java/8.0.16/ ,下载之后将mycat/lib 文件夹下mysql-connector-java/5.1.35 删掉,上传mysql/mysql-connector-java/8.0.16/ 到mycat/lib 目录下。
再给jar包赋权限
[root@oracle-server lib]# chmod 777 mysql-connector-java-8.0.16.jar
二、修改schema.xml
<?xml version="1.0"?><mycat:schema xmlns:mycat=“http://io.mycat/”>
<schema name="TEST" checkSQLschema="true" sqlMaxLimit="100"> <!--(一定要把checkSQLschema改成true)-->
<table name="tb_user" dataNode="dn1,dn2,dn3" rule="auto-sharding-long" />
</schema>
<dataNode name="dn1" dataHost="localhost1" database="db1" />
<dataNode name="dn2" dataHost="localhost1" database="d