The IBM AIX Software Toolbox download page includes a package for MySQL 3.23, but that was a little bit too aged for my purposes. Fortunately MySQL distributes binaries for IBM AIX here:
http://dev.mysql.com/downloads/mysql/5.0.html#aix
That package will work out of the box with 5.3 as well. Download it, and unpack it to /usr/local:
1 2 |
root@server# cat mysql-5.0.45-aix5.2-powerpc-64bit.tar.gz|gunzip|tar xvC /usr/local root@server# ln -s /usr/local/mysql-5.0.45-aix5.2-powerpc-64bit /usr/local/mysql |
There is a file named INSTALL-BINARY which includes these instructions as well as some more information, but here’s a quick overview of the things you need to take care of.
Create a user and group for privilege separation:
1 2 3 |
root@server# <strong>groupadd mysql</strong> root@server# <strong>useradd -g mysql mysql</strong> root@server# <strong>chown -R mysql:mysql /usr/local/mysql-5.0.45-aix5.2-powerpc-64bit</strong> |
Create the MySQL data directory and initialize the grant tables:
1 2 |
root@server# <strong>cd /usr/local/mysql</strong> root@server# <strong>./scripts/mysql_install_db --user=mysql</strong> |
Only the data directory need to be owned by the mysql user, so for security reasons, we will give all other files back to root:
1 2 |
root@server# <strong>chown -R root /usr/local/mysql-5.0.45-aix5.2-powerpc-64bit</strong> root@server# <strong>chown -R mysql /usr/local/mysql-5.0.45-aix5.2-powerpc-64bit/data</strong> |
Start it up:
1 |
root@server# <strong>/usr/local/mysql/bin/mysqld_safe --user=mysql &</strong> |