Bug #16325 Can't connect to a database whose name contains underscore characters
Submitted: 10 Jan 2006 7:06 Modified: 11 Jan 2006 0:30
Reporter: Anthony Cheung Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.12 OS:Windows (Windows XP SP2)
Assigned to: MySQL Verification Team CPU Architecture:Any

[10 Jan 2006 7:06] Anthony Cheung 
Description:
mySQL ODBC driver version: 3.51.12

When I setup a mySQL datasource, all the databases whose names contain an underscore character (_) cannot be accessed, for example, my_db.

How to repeat:
1. Create a database whose name contains an underscore character (_).
2. When a data source is created with server, user and password filled in, the newly created database cannot be seen in the database dropdown box.
[10 Jan 2006 10:43] MySQL Verification Team 
Display data source with my_db

Attachment: bug16325.PNG (image/x-png, text), 32.48 KiB.
[10 Jan 2006 10:45] MySQL Verification Team 
I was unable to repeat the behavior reported. I created a database named
my_db, created the data source and linked a table using Access 2003.

I attached a picture.
[11 Jan 2006 0:30] Anthony Cheung 
Sorry, I have made an mistake.  To cut the story short, I forgot to grant the permssion to a particular user.

Anyway, thank you very much for the reply.