User Tools

  • Logged in as: anonymous (anonymous)
  • Log Out

Site Tools


mantisbt:systemi

This is an old revision of the document!


System i Support

Mantis support for IBM System i platform (AS/400, iSeries) and DB2.

* Installing MySQL on System i

http://dev.mysql.com/downloads/mysql/5.0.html#downloads
(as of 2007-01-30)

IBM AIX downloads 
AIX 5.2 (POWER, 64-bit)	Standard	5.0.27	28.1M	
                        Max	        5.0.27	28.1M	

Download filename: mysql-max-5.0.27-aix5.2-powerpc-64bit.tar.gz

W:\LIVE\mantis-sql>dir
 Directory of W:\LIVE\mantis-sql
10/20/2006  21:24           80,732,160 mysql-max-5.0.27-aix5.2-powerpc-64bit.tar

W:\LIVE\mantis-sql>ftp   -i   as400
Connected to AS400.
220-QTCP at 192.168.0.222.
220 Connection will close if idle more than 5 minutes.
User (RUBY:(none)): yourUserId
331 Enter password.
Password: **********
230 YOURUSERID logged on.
ftp> cd /usr/local
550-NAMEFMT set to 1.
250 "/usr/local" is current directory.
ftp> ls
200 PORT subcommand request successful.
125 List started.
Zend/
250 List completed.
ftp: 7 bytes received in 0.00Seconds 7000.00Kbytes/sec.
ftp> bin
200 Representation type is binary IMAGE.
ftp> put *.tar
200 PORT subcommand request successful.
150 Sending file to /usr/local/mysql-max-5.0.27-aix5.2-powerpc-64bit.tar
ftp: 80732160 bytes sent in 11.36Seconds 7107.33Kbytes/sec.
ftp>quit

On the AS/400 command line, as QSECOFR, issue the following commands (responses not shown):

call  qp2term
cd  /usr/local
tar  -xvf  mysql-max-5.0.27-aix5.2-powerpc-64bit.tar 
ln -s mysql-max-5.0.27-aix5.2-powerpc-64bit  mysql 
cd /usr/local/mysql
scripts/mysql_install_db

Continue with Unix Post Install docs at http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html

Start MySQL

> cd . ; ./bin/mysqld_safe &                                        
  [1]     128192                                                    
  # Starting mysqld daemon with databases from /usr/local/mysql/data

First, set default priviledges: http://dev.mysql.com/doc/refman/5.0/en/default-privileges.html

> ./bin/mysql -u  root
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 1 to server version: 5.0.27-max
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
  mysql>
> SET PASSWORD FOR ''@'localhost' = PASSWORD('secret');
  Query OK, 0 rows affected (0.00 sec)
  mysql>
> SELECT Host, User FROM mysql.user;
  +-------------------+------+
  | Host              | User |
  +-------------------+------+
  | AS400             |      |
  | AS400             | root |
  | localhost         |      |
  | localhost         | root |
  +-------------------+------+
  4 rows in set (0.01 sec)
  mysql>
> SET PASSWORD FOR ''@'AS400' = PASSWORD('secret');
  Query OK, 0 rows affected (0.06 sec)
  mysql>
> UPDATE mysql.user SET Password = PASSWORD('secret') -> WHERE User = '';
  Query OK, 0 rows affected (0.07 sec)     
  Rows matched: 2  Changed: 0  Warnings: 0 
  mysql>
> UPDATE mysql.user SET Password = PASSWORD('secret')  WHERE User = 'root';
  Query OK, 2 rows affected (0.01 sec)
  Rows matched: 2  Changed: 2  Warnings: 0
  mysql>
> FLUSH PRIVILEGES;
  Query OK, 0 rows affected (0.00 sec)
  mysql>

Optionally remove anonymous access:

mysql> DELETE FROM mysql.user WHERE User = ''; 
mysql> FLUSH PRIVILEGES;

* Using native i5 DB2/400

http://wiki.splitbrain.org/wiki:syntax

mantisbt/systemi.1170223161.txt.gz · Last modified: 2008/10/29 04:31 (external edit)

Driven by DokuWiki