Connecting to mysql database with a '-' in name with .net connector 1.0.9

[carpe-diem]

Hellos, did anyone have trouble connecting to mysql databases with '-' in their database and/or user name?

I can't get it to work, unless I first connect to database 'test' and then change the database with ChangeDatabase function. But even then it only works on every second request

I tried wrapping the database name in `` but it just changed the error to Access denied. The same happens when I also enclose user name in ``.

 

[Stephen]

Eh, what about taking a dump of the DB and recreating it without a - in the name, it may be easier

 

[carpe-diem]

Eh, what about taking a dump of the DB and recreating it without a - in the name, it may be easier

I don't think it is possible. The dash is part of my client's user name at jodo~ and I'm not sure what will happen if I try changing the user name in CPanel (If it's even possible)
.

 

[Stephen]

oh, you are right, I thought it was the DB name having a - in it

 

[carpe-diem]

oh, you are right, I thought it was the DB name having a - in it

Well, you were right - db name has a dash it too. Since it is created from part of my username (with dash);