"Original" Install MYSQL (AIX)

This article takes mysql-5.1.66-aix5.3-powerpc-64bit.tar.gz as an example

Where: Mysql-5.1.66:mysql version

Aix5.3:aix version

Powerpc:aix Machine CPU Model

64bit: Number of digits

Installation Machine Condition:

1. Download the MySQL Package

: http://dev.mysql.com/downloads/

2. Unpack the GZ Package

Root-shell> Gunzip mysql-5.1.66-aix5.3-powerpc-64bit.tar.gz

Root-shell> Tar xvf Mysql-5.1.66-aix5.3-powerpc-64bit.tar

3. Change the Directory

4. Migrating MySQL to the/usr/local directory

root-shell> MV Mysql-5.1/usr/local

5. Create a link method for easy use, you can create a shortcut

Root-shell> cd/usr/local

root-shell> ln-s mysql-5.1 MySQL

6. Create user groups and users

root-shell> Mkgroup MySQL

root-shell> useradd-g MySQL MySQL

Root-shell> cd/usr/local

Root-shell> chown-r mysql:mysql./mysql-5.1

7. Execute the mysql_install_db script

Root-shell> cd/usr/local/mysql/scripts

root-shell>./mysql_install_db--user=mysql--basedir=/usr/local/mysql--datadir=/usr/local/mysql/data

8. Change the password

root-shell>/usr/local/mysql/bin/mysqladmin-u root password ' root '

9. Start MySQL

Root-shell> Mysqld_safe--user=mysql &

10. Modify Path

The above calls to MySQL are all using absolute paths, modified. CSHRC add/usr/local/mysql/bin to the PATH variable
Setenv PATH $PATH:/usr/local/mysql/bin

One. mysql configuration.

Set Root user Rights.

Steps	Command	Description
1	Su Root	Go to Super User
2	Mysql	Login MySQL Server
3	GRANT all privileges on * * to ' root ' @ '% ' identified by ' root ' with GRANT OPTION;	Set permissions

Set up network access, meditation system needed.

Access to the super user.

Modify the "my.cnf" file. There are two types of configuration file paths: "/etc/my.cnf" or "/etc/local/my.cnf".

"Original" Install MYSQL (AIX)