Hi, I'm having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server.
Also, when I check the defaults config file for MySQL I get this message:
Default options are read from the following files in the given order:
/etc/my.cnf ~/.my.cnf /usr/local/mysql/etc/my.cnf
I am guessing that MySQL uses the configuration file in the last location '/usr/local/mysql/etc/my.cnf'? Is this so?
Note that no my.cnf file found in that location, the config file was created by MySQL in '/etc/my.cnf'. So can this be the problem? If so how do I set MySQL to look for the '/etc/my.cnf' last instead of '/usr/local/mysql/etc/my.cnf'?
Software/Hardware used: MySql 5.0.45, Zend Server 5.6.0