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;
mantisbt/systemi.1170223161.txt.gz · Last modified: 2008/10/29 04:31 (external edit)