Rod Flohr on the web
Rod Flohr on the web
Some things you really should know, and lots of other stuff
 
Skip to content
  • Home
  • Blog

Month: March 2014

2 Comments

Install MySQL using the Zend DBi installer with Zend Server

  By admin March 16, 2014 March 24, 2014 Zend DBi (MySQL)

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

No comments

Zend DBi may not respond to changes in the my.cnf configuration file

  By admin March 16, 2014 March 24, 2014 Zend DBi (MySQL)

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

No comments

Set the Zend DBi MySQL root user password

  By admin March 16, 2014 March 24, 2014 Zend DBi (MySQL)

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

No comments

Install the IBMDB2i storage engine for Zend DBI MySQL

  By admin March 16, 2014 March 24, 2014 Zend DBi (MySQL)

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

No comments

Deploy phpMyAdmin using Zend Deployment

  By admin March 16, 2014 August 7, 2014 phpMyAdmin, Zend DBi (MySQL), Zend Deployment

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

No comments

Automatically start Zend DBi MySQL at start up

  By admin March 16, 2014 March 24, 2014 Zend DBi (MySQL)

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

One Comment

Start the Zend DBi MySQL Daemon job and verify it is running

  By admin March 15, 2014 March 24, 2014 Zend DBi (MySQL)

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

No comments

Troubleshoot Zend DBi MySQL daemon start up failures (mysql.sock)

  By admin March 15, 2014 March 24, 2014 Zend DBi (MySQL)

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

No comments

QGPL in system library list prevents Zend DBi MySQL daemon from starting

  By admin March 15, 2014 March 24, 2014 Zend DBi (MySQL)

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

No comments

Port 3306 in use prevents Zend DBi MySQL daemon from starting

  By admin March 15, 2014 March 24, 2014 Zend DBi (MySQL)

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

12
  • Categories

    • At Home (1)
    • Uncategorized (2)
    • Zend on IBM i (23)
      • Apache (IBM HTTP Server) (1)
      • IBM i OS (3)
      • Zend DBi (MySQL) (18)
        • phpMyAdmin (2)
      • Zend Server for IBM i (4)
        • Zend Deployment (2)
  • Recent Posts

    • Delete MySQL for a clean install, or just to get rid of it
    • Edit any file in Navigator
    • End jobs on the IBM i by User and Job Name – ENDUSRJOB
    • Deploy phpMyAdmin compatible with MySQL 5.1
    • How to exclude Apache Access log entries
  • Recent Comments

    • William S Zimmerman on Start the Zend DBi MySQL Daemon job and verify it is running
    • K on Welcome to rodflohr.com
    • Paul Wood on End jobs on the IBM i by User and Job Name – ENDUSRJOB
    • Benny on Deploy phpMyAdmin compatible with MySQL 5.1
    • admin on Deploy phpMyAdmin compatible with MySQL 5.1
  • Archives

    • April 2015
    • September 2014
    • August 2014
    • May 2014
    • April 2014
    • March 2014
    • February 2014
    • January 2014
    • December 2013
    • November 2013
  • Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
This text can be changed from the Miscellaneous section of the settings page.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, cras ut imperdiet augue.
Powered by Parabola & WordPress.