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 IBM i , 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 IBM i 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):

  1. Open the Setup Tool by running the following command:

   go zendsvr/zsmenu

  1. Select Option 6 - MySQL Management Menu.

  2. 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.
See the 'Testing your MySQL Connection using Zend Studio', section, below, for more on connecting to the MySQL database.

Press F3 to finish and exit the installation process.

Testing your MySQL Connection using Zend Studio

If you installed MySQL, you can use Zend Studio in order to test your MySQL connection and access your database.

Note:

See http://www.zend.com/en/products/studio/for-i5os for more on Zend Studio for i/OS.

 

 

Instructions on how to complete a procedure

To test your MySQL connection:

  1. Open Zend Studio.

  2. From Studio's File Manager, click the SQL tab.

  3. Right-click and select the Add SQL Server option.
    The Add SQL Server dialog will appear.

  1. Enter the SQL Server Settings in the fields.
    The settings include:

  • Server Type - Select MySQL.
  • Server Name (Alias) - Enter a server name. This will appear on the SQL Tree (of the File Manager).
  • Host Name/IP - Enter your server address.
  • Port - When you choose a Server Type, the default port appears in this field automatically.
  • Database Name - Enter 'mysql'.
  • User Name - Enter the default password 'root'.
  • Password - Leave the password field blank.

  1. Click Test to attempt to connect to the SQL Server using the settings and connections currently entered in the Add SQL Server dialog box.
    If the connection is successful, a 'Connection Successful' dialog will appear.

  2. Click OK.
    Your SQL Server will be added to the SQL tab, and you will be able to view and access the tables contained in it.

 

See the Zend Studio for i/OS User Guide for more information.

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.

 

 

Related Links

Related Links:

Installing Zend Server for IBM i

http://dev.mysql.com/doc/refman/5.0/en/installation-i5os.html