使用静态IP的MySQL数据库连接 [英] Mysql database connection using static IP

问题描述

嗨
我有静态IP
我需要使用具有数据库的静态IP连接系统.
我已经完成了来自调制解调器的端口转发.

我尝试了
CONNECTION_STRING为
服务器=静态IP;端口= MYPORT; uid =用户ID; pwd =密码";
它显示错误
无法连接mysql

我试过了
CONNECTION_STRING为
"UID = USERID; pwd = PASSWORD;主机=静态IP;端口= MYPORT;数据库=用户详细信息;直接= true;协议= TCP;压缩= false;缓冲池= true;最小池大小= 0;最大池大小= 100;连接寿命= 0;;

但没有运气

怎么了:(

任何人都可以帮助我
谢谢
Saranya1388

Hi
I have static IP
I need to connect the system using Static IP which is having database.
I have done Port forwarding from Modem.

I tried the
CONNECTION_STRING as
"server=STATIC IP;port=MYPORT;uid=USERID;pwd=PASSWORD";
It showing the error
Unable to connect mysql

I tried the
CONNECTION_STRING as
"UID=USERID;pwd=PASSWORD;Host=STATIC IP;Port=MYPORT;Database=user_details; Direct=true;Protocol=TCP;Compress=false;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;";

But no luck

What is the mistake? :(

Anyone can help me
Thanks
Saranya1388

推荐答案

嗨Saranya，

试试这个

< add key ="connectionStrings" value ="Server = ip; Database = abc; Uid = xx; Pwd = yyy;使用过程主体= true;处理为boolean = false的微小值;允许用户变量= true;使用受影响的行=真的;" />

它与我的代码一起使用.

Hi Saranya,

Try this

<add key="connectionStrings" value="Server=ip;Database=abc;Uid=xx;Pwd=yyy;use procedure bodies=true;treat tiny as boolean=false;allow user variables=true;use affected rows=true;" />

Its working with my code.

这篇关于使用静态IP的MySQL数据库连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！