我无法将新数据源（mysql）添加到我的项目中 [英] I can't add new data source (mysql) to my project

问题描述

i无法向我的项目添加新数据源

此错误出现

i can't add new data source to my project
this error appear

a connection attempt failed because the connected party did not properly respond after a period of time , or established connection failed because connected host has failed to respond

server=localhost;User Id=root;password=123;Persist Security Info=True;database=je_eberspharma;Character Set=utf8;Convert Zero Datetime=True;Connect Timeout=100;Default Command Timeout=1000

我尝试了什么：



- 我安装了mysql-connector-net-6.6.5

- 完全权限root

- 当我应用thiscode SET GLOBAL net_read_timeout = 10000时某些表被导入但我不能重复这一步。

What I have tried:

- i installed mysql-connector-net-6.6.5
- full permission to root
- when i applied thiscode SET GLOBAL net_read_timeout = 10000 some table was imported but i can't repeat this step again.

推荐答案

我通过编辑Co来解决它将

i solved it by edit the Collation of

varchar

字段添加到

utf8_general_ci

和连接字符串：

and the connection string to :

server=localhost;User Id=root;password=123;Persist Security Info=True;database=je_eberspharma;Character Set=utf8;Convert Zero Datetime=True;Default Command Timeout=30000;Connect Timeout=100

这篇关于我无法将新数据源（mysql）添加到我的项目中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！