You are currently viewing Zend Server 5.x documentation. Click here to view the latest Zend Server online documentation.

You are here: Zend Server for IBM i Installation Guide > MySQL Installation

MySQL Installation

This section describes how to install MySQL, if you skipped the MySQL installation option during the interactive installation or used the silent installation.

Note:

When you install Zend Server for IBMi , you can use the full or custom installation types to choose to install phpMyAdmin and MySQL. Both phpMyAdmin and MySQL are installed on your local machine under the default location <install_dir>\phpMyAdmin and <install_dir>\MySQL.
A link to this phpMyAdmin installation is added in the Zend Server for IBMi Dashboard.

To begin MySQL Installation select Option 6 ‘MySQL Management menu ’ from the Send server Service menu (GO ZENDSVR/ZSMENU):

MySQL installation (optional)

Press ENTER to start MySQL installation or press F3 to skip
MySQL installation

F3=Exit

MySQL Installation Option

Press Enter to start the MySQL installation or F3 to skip MySQL installation.

Note:

You can install the MySQL database later using the Setup Tool.
To install MySQL following installation:
1. Open the Setup Tool by running the command go zendsvr/zcmenu in your i/OS emulator screen.
2. Select Option 6 - MySQL management menu.
3. You will be prompted to install the MySQL database.
Note: MySQL must be installed by QSECOFR.

If you pressed Enter and MySQL is already installed in the directory /usr/local/MySQL, the following prompt will appear:

MySQL installation (optional)

MySql is already installed.

F3=Exit

MySQL already installed

If this prompt has appeared, MySQL is already installed. Press F3 to finish the installation.

If MySQL has not been previously installed, it will be installed now:

MySQL installation (optional)

MySQL is being installed and configured.
Please wait ...

F3=Exit

MySQL installation

A dialog will appear reminding you to set a password for the MySQL root user:

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h <Your_Machine> password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl
Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
Press ENTER to end terminal session.

MySQL Instructions

In addition to the instructions in the dialog, the MySQL Daemon can later be stopped/started through the Setup Tool.

Instructions on how to complete a procedure

To start/stop your MySQL Deamon (after the MySQL installation):

Open the Setup Tool by running the following command:

go zendsvr/zsmenu

Select Option 6 - MySQL Management Menu.
In the following screen, select Option 4 - Start MySQL daemon or Option 5 - Stop MySQL daemon.

Press Enter to continue.

MySQL installation (optional)

MySQL is installed in directory /usr/local/MySql
and library ZMYSQL

F3=Exit

MySQL Installation Confirmation

A confirmation message will appear stating the location of your MySQL installation.

Press F3 to finish and exit the installation process.

Verifying the Installation and Setting the Root User Password

The phpMyAdmin tool distributed with Zend Server for IBMi is an open source PHP application that makes it easier to manage MySQL using a graphical interface. You can use phpMyAdmin to set a password for the root user.

Instructions on how to complete a procedure

To verify the installation and set the Root User password:

Go to http://<your IBM i IP address>:10088/phpmyadmin/
To log in, use Username 'root' (no quotes), and leave the password empty (DO NOT type in a blank, just leave it empty).
Click Go.
The home page for phpMyAdmin on your server is displayed.
In the Actions section, click Change password.
The "Change password" page is displayed.
Select the Password radio button, and type in your desired password. Type it in again in the next text box.
Leave the rest at their default values, and click Go.
If this is successful, you will see this message: "The profile has been updated."
Return to the phpMyAdmin home page by clicking the icon that resembles a house.
On the home page, select the Privileges tab.
The User overview table is displayed .
Notice that there are a few entries in this table for user 'root'. Only the user for host 'localhost' will have a password (this is the entry you have just changed).You can set passwords for user 'root' on other hosts by editing each entry.
To edit an entry:

Click the Edit icon at the end of the row for the entry.
On the Edit page, fill in the Change password form as specified in steps 5-6.
Return to the Privileges tab to edit the passwords for other rows.

Note:

To uninstall MySQL:
1. Stop the ZMYSQL subsystem
2. Delete ZMYSQL library
3. Remove the directory /usr/local/mysql-5.0.45-i5os-power-64bit
4. Remove the directory /usr/local//mysqldata
5. Remove the link /usr/local/mysql
6. Remove /etc/my
See http://dev.mysql.com/doc/refman/5.0/en/installation-i5os.html-(external link) for more information.