mysql remote access does not work as expected when database name uses _ in the name
While changing a database access to remote (all), the user creation is missing to properly escape the underscore character.
To reproduce:
create a database named c1_web1
change then the database to be remotely available.
try to access remotely, it fail
Reason:
Look mysql.db records, the field Db contains 'c1_web1' while it should contain 'c1_web1' See escaping like patterns http://dev.mysql.com/doc/refman/4.1/en/string-comparison-functions.html
Note:
The record is properly created for the localhost