c# and mysql

Hi guys.
I've got mysql server on my computer and I'm connecting to it from my program written in c#. Everything's working till I use localhost. My connection-string looks like this :

string MyConString = "SERVER=localhost;" + "DATABASE=nero_db;" + "UID=root;" + "PASSWORD=asdasd;";

I would like to make it work with my external IP adress, so I tried to make it this way:

string MyConString = "SERVER=xxx.xxx.xx.xx:3306;" + "DATABASE=nero_db;" + "UID=root;" + "PASSWORD=asdasd;";

I forwarded port 3306 to my mashine in router.
SERVER="localhost:3306" is not even working...

Any ideas/experiece?
Thanks in advice.

I'm using VS STUDIO 2008 , connector, and mysql 5.1.48

You're an idiot.

>>2
You can't just go you're an idioting him without telling him to use the [code] tags!

So is MySQL running on port 3306?

yes it is

fuckyou

SERVER=127.0.0.1  works
SERVER=192.168.0.100 - my local ip - dowsnt work ;/  ...

SERVER=127.0.0.1  works
SERVER=192.168.0.100 - my local ip - dowsnt work ;/  ...

isn't that a whole ordeal you have to deal with in MySQL that allows remote access from outside the localhost connection.

Why don't you keep the program on the same machine as the database and run it from elsewhere? It'd trust you more then.

VS STUDIO 2008 , connector, and mysql 5.1.48

Running a server on a Windows box.
Now you have two many, many problems.

10 ~ It is on the same machine , I just wanted to make it connectable from other computers.

Thanks Darkkal, I set access in my db and it works now.
:)