mysql插件连接不上mysql

Question

我用DolphinDB database的mysql插件连接mysql，代码如下：

loadPlugin("plugins/mysql/PluginMySQL.txt")
conn =mysql::connect("localhost",3306,"root","12345","mydb")

我执行后提示错误：

ConnectionFailed : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ((nullptr):0), with errno: 2002

请问这个可能是什么原因？谢谢！

Answer 1

不要用localhost，请改用ip地址。比如：

conn =mysql::connect("192.168.1.18",3306,"root","12345","mydb")

mysql插件不支持sock连接，只支持tcp连接。