period in userid for mysql connectionstring

[Hokkie]

Hi,

I need to connect to a mysql database with the mysql connector from mysql.com. My webserver admin has given me a logon name and password to connect to the database, and for some reason there's a period in the logon name:

"hoorspelfabriek.nl"

When I try to connect, I get the error message that the user is denied access, and behind that the portion of the username up to and including the point (but without the 'nl' bit). I can connect fine using the myphpadmin application on the webserver.

Does the UserID (or UID) parameter in the connectionstring not take periods? I've tried using single quotes and square brackets but no use, still access denied.

Or can I not use the login name and password for myphpadmin as logon credentials from a C# application?

Any help on this greatly appreciated.

 

[mthakershi]

Did you look at this?

http://bugs.php.net/bug.php?id=31418

Malay

 

[Hokkie]

Hi Malay,

no I didn't but I have now. Thanks for the link. The article is about connection to MySql using PHP scripting language rather than through C# code, so not directly helpful but at least it got me thinking about using php scripting as well.

Anyway, I think I'll experiment a little more with escape sequences, and update this thread with the result.

Any other ideas still welcome!