RE: PHP and mySQL startup

From: Jeff Crosby

I have successfully installed PHP and MySQL onto our System i.

Did you do this manually or install Zend Core?

"MySQL error 1130. Host 192.168.0.35 is not allowed to connect to this MySQL Server."

This is "normal" with any MySQL installation. There is a mysql database that handles the security for MySQL. The Zend installer adds an entry to the user table to allow access from your system. If you want access from other locations, you need entries in the user table. (Check MySQL documentation for alternatives; there are many ways to configure MySQL.)

The user table has fields for host, user, password, and what permissions are allowed. You could allow user root to do anything from localhost but be read only from 192.168.0.35, for example.

You should be able to get to a mysql command line from within "CALL QP2TERM" but I'd have to dig up specifics if you don't know how to do that. Let's just say that I've done it, but it wasn't easy.

Another alternative is to install (i.e. unzip and put in htdocs folder) phpMyAdmin which will make this process much easier.
--
Sean Porterfield

This email is confidential, intended only for the named recipient(s) above and may contain information that is privileged. If you have received this message in error or are not the named recipient(s), please notify the sender immediately and delete this email message from your computer as any and all unauthorized distribution or use of this message is strictly prohibited. Thank you.