handle @ in mongodb connection string

Question

I have connection string

<add key="MongoDBConnectionString" value="mongodb://user:password@123@127.0.0.1/?safe=true"/>

password is password@123 so host is parsing 123@127.0.0.1, how can i handle @ in credential

Edit I have tried to escape it but still same problem

 <add key="MongoDBConnectionString" value="mongodb://user:password&#64;123@127.0.0.1/?safe=true"/>

Edit Thanks to alexjamesbrown for helping, following escaping working for me.

<add key="MongoDBConnectionString" value="mongodb://user:password%40123@127.0.0.1/?safe=true"/>

According to this question: http://stackoverflow.com/questions/7486623/mongodb-password-with-in-it It won't work. — Alex, Jan 15 '13 at 10:49
@alexjamesbrown : working for me. may be because I am using C# driver not node. — Govind Malviya, Jan 15 '13 at 10:55
Possible duplicate of [MongoDB password with "@" in it](https://stackoverflow.com/questions/7486623/mongodb-password-with-in-it) — Andrey Hohutkin, Sep 03 '19 at 19:33

score 26 · Accepted Answer · answered Jan 15 '13 at 11:00

I posted this as an answer before, but it converted it to a comment...

Escape your @ sign to %40 (in your password string.)

As per the comments, I believe this will work using the C# driver, but might not work when using other drivers (mongoose on node.js for example)

1 Answers1