This article tells how to install MySQL on a partition that does not have MySQL currently installed. To check whether MySQL is installed, please review this post: How to Verify MySQL is Installed on your IBM i Zend DBi is a MySQL build for IBM i that is packaged by … Continue reading
If changes made to the my.cnf configuration file for MySQL do not seem to be changing the behavior of your Zend DBi installation of MySQL, there are two issues to look at. 1. my.cnf is “World-writable” MySQL will not process the my.cnf configuration file on start up if the file … Continue reading
Before you begin using MySQL, it is important to password protect the root user. User root in MySQL is the most powerful user, similar to QSECOFR on IBM i, admin on Windows, or root on Linux/Unix. Prerequisites: Before you can set the root user password, you must first install Zend … Continue reading
One really interesting feature of MySQL is that it can use different storage engines. One of the engines available for MySQL is IBMDB2i. This engine uses DB2 on the IBM i to store data. This provides the possibility of downloading and installing a free LAMP application, and being able to access … Continue reading
As much fun as it is to interact with MySQL from a command line, IBM i people expect more. We want convenience. We want ease of use. We want a Graphical User Interface. We want phpMyAdmin. Starting with Zend Server for IBM i version 6.3.0, Zend is packaging a number … Continue reading
One of the nice features of Zend Server for IBM i is that it will start up automatically whenever the IBM i is restarted. To be more specific, it starts whenever subsystem QSYSWRK is started. Zend DBi does not provide for automatic start up of the Zend DBi MySQL server … Continue reading
The MySQL server is a daemon, meaning it is a constantly running process that communicates via TCP/IP. In order to use Zend DBi MySQL, the Zend DBi MySQL server daemon must be running. Prerequisite: Zend DBi must be installed. The following article can help with that: Install MySQL using the … Continue reading
To determine if you need to troubleshoot the Zend DBi MySQL start up, you should first try to: Start the Zend DBi MySQL Daemon job and verify it is running If the ZENDDBID job will not start, you will often see some message (after a bit of digging around) that … Continue reading
This article presents one of the troubleshooting steps for Zend DBi MySQL daemon start ups, found in this article: Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock) To check this issue, please log on to a 5250 session and enter this command: dspsysval qsyslibl The output will be similar … Continue reading
This article presents one of the troubleshooting steps for Zend DBi MySQL daemon start ups, found in this article: Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock) One reason MySQL may fail to start is if the default MySQL port 3306 is in use. One way to check … Continue reading