mysql 命令行无法建立连接,server中也配置了如下的内容,lib 下的jar包也换成了8.0的版本,就是不行,
<property name="useHandshakeV10">1</property>
<property name="defaultSqlParser">druidparser</property>
日志如下:
2020-10-21 21:44:31.496 INFO [Timer0] (io.mycat.backend.datasource.PhysicalDatasource.getConnection(PhysicalDatasource.java:564)) - no ilde connection in pool 629572077 ,create new connection for M1 of schema foodie-shop-dev totalConnectionCount: 0 increamentCount: 1
2020-10-21 21:44:31.496 INFO [Timer0] (io.mycat.backend.datasource.PhysicalDatasource.getConnection(PhysicalDatasource.java:564)) - no ilde connection in pool 1939709513 ,create new connection for M1 of schema foodie-shop-dev totalConnectionCount: 0 increamentCount: 1
2020-10-21 21:44:31.501 WARN [$_NIOREACTOR-6-RW] (io.mycat.backend.mysql.nio.MySQLConnectionAuthenticator.handle(MySQLConnectionAuthenticator.java:91)) - can't connect to mysql server ,errmsg:Host '192.168.0.40' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' MySQLConnection [id=221, lastTime=1603287871494, user=hanye, schema=foodie-shop-dev, old shema=foodie-shop-dev, borrowed=false, fromSlaveDB=false, threadId=0, charset=utf8, txIsolation=3, autocommit=true, attachment=null, respHandler=null, host=192.168.0.42, port=3306, statusSync=null, writeQueue=0, modifiedSQLExecuted=false]
2020-10-21 21:58:00
老师,我这里改成jdbc 的连接方式就可以,native 实在是搞不定了
2020-10-22 00:02:35
你的日志中为什么会有foodie-dev-shop,配置文件中没有这个schema
2020-10-22 01:53:18
恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧
0 星