Sometimes you may need to get a fresh start with MySQL. If so, you will want to do a clean install, which is just deleting the existing installation and doing a new installation. Other times, you may just want to remove MySQL. This article can help you out either way. … Continue reading
The latest version of phpMyAdmin available for download from the Zend Server Guide Page requires MySQL 5.5. At the time of this writing, MySQL 5.5 is not yet available on IBM i. It is in the works, but in the meantime, we need a version of phpMyAdmin that will work … Continue reading
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