Access denied to MySQL for user

[bazianm]

Hi,

I have a weird problem. I know WHAT it is, just not how to fix it.

I am setting up a development environment for a merchant web site so I have to conform to the user name and password the merchant is using on the database. The user name has an underscore in it (e.g., u_x). I created the user and password but I cannot access the database.

I tried with command line, no luck no matter what I did. I tried with MySQL Workbench and it worked but only when I escaped the _.

I have given privs to the user for the database so that is not the issue.

Any ideas?