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.