PHP and mySQL startup

All,

I have successfully installed PHP and MySQL onto our System i. Other than
that, I am a long time RPG Developer and know absolutely squat about PHP. I
have dabbled in SQL.

What we want to do is put up a "Product Search" on our GoDaddy hosted
website, which I figure should be relatively simple for a good PHP
developer. I plan on hiring someone local to do the actual PHP. But that
local person isn't going to know squat about the i.

I already have the product search table built as a DB2/400 table (it is
defined via DDL, not DDS). I know it has to be reworked as a MySQL table,
and that subsequent to that, it can be seen as a DB2/400 table as well. I
don't know how to proceed in getting that done. A number of the i5/OS and
Getting Started links on the zend.com website are broken. Zend Studio looks
virtually nothing like the pictures in the installation and users guides
(because they went to the next version of Eclipse in Zend Studio and haven't
updated the documentation).

I downloaded a windows program from Sun called MySQL Administrator to my PC
and tried to connect to MySQL on the i. Not allowed - I get an error box
"MySQL error 1130. Host 192.168.0.35 is not allowed to connect to this
MySQL Server." 192.168.0.35 is the IP address of my PC. This tells me that
it's running on the I and that's about it.

I opened a support ticket with Zend and they suggested I take their $600
course. Spending $600 for that isn't in the cards right now. I could
contact the mySQL people at Sun (They've already emailed me) but I don't
think they'll be too knowledgeable about the setup on the i.

All I was really hoping for is to get the MySQL table set up properly, be
able to connect to the MySQL database from Zend Studio, and then turn a PHP
developer loose. The PHP could be developed (or tweaked from an already
existing search) on my PC within our office. When satisfied, we could
upload the whole shebang to GoDaddy. It would remain on my PC as well, so I
could tinker, tweak, learn, and play to my hearts content without affecting
the actual website. Sound doable?

I essentially have 2 problems: 1) How to get this single DB2/400 table to
be a MySQL table, and 2) how to connect to the MySQL database on the I from
my PC.

It shows just how sheltered a life I've led in that it still seems really
odd that one has to "connect" to a database to use it. At the same time,
the network consultant/website developer I have come in can't seem to get
his head around the idea that the database on the i is "just there".

I appreciate any help in this. I truly don't know how I'd survive without
this list.

--
Jeff Crosby
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
www.dilgardfoods.com

The opinions expressed are my own and not necessarily the opinion of my
company.  Unless I say so.