Thanks Brian. I take it that just starting the mySQL server on the iSeries will make it listen on port 3306? Nothing extra to start like needed for native DB2 DRDA or ODBC ports to open (STRHOSTSVR) ?
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of BMay@xxxxxxxxx
Sent: Tuesday, December 01, 2009 9:54 AM
To: Midrange Systems Technical Discussion
Subject: RE: MySQL on i using DB2
MySQL on i is really no different than any other flavor of MySQL. You can
connect to the MySQL database running on i just like you would if it were
running on any other platform. MySQL listens on port 3306 unless you have
changed it. I know it works because I use a PC based database design tool
(MySQL Workbench) to connect to my box running MySQL remotely all the
time.
So the short answer is yes you can do exactly what you are asking.
Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi
Young i Professionals
http://www.youngiprofessionals.com
Mike Cunningham <mike.cunningham@xxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
12/01/2009 08:33 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc
Subject
RE: MySQL on i using DB2
For the same reason the mySQL to DB2 connection was created by IBM.
Existing application written to the mySQL standard for database access and
I would like to have it continue to run where it runs now but use the
iSeries and DB2 as its database.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dennis Lovelady
Sent: Tuesday, December 01, 2009 8:55 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: MySQL on i using DB2
With my SQL setup on system i using the connector for DB2, could an
application running on another platform access the mySQL database on
the i? e.g. Could I write a application that ran on a windows desktop,
or a mac, or another system i and have it access the mySQL database
(actually DB2). If so I would assume that I would use an ODBC driver
for mySQL. Is there anything that would need to be done on the system i
side to allow the connection? I read the IBM redbook and did not see
anything about how to configure mySQL to accept external connections.
Why would you want to, when DB2 is so easily accessible as it is?
I would imagine that you'd run into all sorts of security issues if you
tried something like this, so I doubt that it's allowed. And if this is a
circumvention for such security issues, I doubt you'd want to exercise it.
Having said that, I cannot say one way or another.
Regards,
Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
Phil Rizzuto (to Yogi Berra, driving to a banquet) : "Yogi, we're lost."
"Yeah, but we're making good time."
midrange.com
