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
It is possible to use Navigator to look at and edit the contents of just about any file in the IFS. By default, it is only possible to edit files with extensions that can be edited with Notepad. Examples are files that end with .log, or .txt. Other files that … Continue reading
Sometimes we know the name and user of a job we might want to end, but we won’t know the job number until the job is submitted. There does not seem to be an IBM i command to end jobs when the job numbers are not known, and I have … 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
The Apache Access log records each request for content received by your Apache web server. This is important information to have available. You can see where requests are coming from and detect requests that may be attacks from hackers seeking to get in to your system. However, you can also … Continue reading
The word is already out on this, but this is just to add another post to amplify the message. The Heartbleed vulnerability in OpenSSL does not affect Zend Server for IBM i. In fact, Heartbleed does not affect IBM i at all. Basically, the latest version of OpenSSL on IBM … 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