Unable to Connect to MySQL ODBC.

building semantic layer
1

Hi,

I am trying to access MySQL ODBC connection from IDT and system is generating error : Connection failed:(HY000) (mySQL)(ODBC 5.1 driver) host server is not allowed to connect to this MYSQL server.

Now in order to allow it to connect, i installed the ODBC driver 5.1 , 5.3 ANSI driver, 5.3 unicode drivers (for 64bit OS), and still same this error persists, where as i believe with these drivers installed it should allow to access MySQL ODBC connections.

Could It be because, MySQL server is 32bit and the host server i am trying access MySQL from is 64bit, though BI Server platform is strictly 64bit, but still it allows data source connectivity for 32bit OS, so i believe this might not be a hurdle for the error.

Please help on this.

Thanks In Advance. :slight_smile:

umarnayab (BOB member since 2013-06-05)

2

Di you figure this out? I don’t see MySQL as a source data for universe work in BOE4.1 Universe designer…

a/

angelsd1 :us: (BOB member since 2005-10-21)

3

This is likely to be MySQL security, by default MySQL limits the machines that can connect to the database to the localhost of the MySQL server. Your MySQL dba will need to change you user account, or the user account to be used by the BO connection to be able to connect from whatever client machines (IP addresses usually) are being used. You can set a user to be able to connect from ALL machines in MySQL by using a wildcard, but not sure many prod MySQL dbas would like it.

ABILtd :uk: (BOB member since 2006-02-08)