Jumat, 07 Desember 2012

Install MySQL 5.5 di CentOS 5.x

1. Install CentOS 5.x
2. Download file MySQL 5.5 yang antara lain:
    Red Hat & Oracle Linux 5 (x86, 32-bit), RPM Package Embedded 62.4M - OK
        MySQL-embedded-5.5.28-1.rhel5.i386.rpm
 
    Red Hat & Oracle Linux 5 (x86, 32-bit), RPM Package Development Libraries 3.4M - OK
         MySQL-devel-5.5.28-1.rhel5.i386.rpm
 
    Red Hat & Oracle Linux 5 (x86, 32-bit), RPM Package Test Suite 40.4M - OK
        MySQL-test-5.5.28-1.rhel5.i386.rpm
 
    Red Hat & Oracle Linux 5 (x86, 32-bit), RPM Package Compatibility Libraries 5.1M - OK
        MySQL-shared-compat-5.5.28-1.rhel5.i386.rpm
 
    Red Hat & Oracle Linux 5 (x86, 32-bit), RPM Package Client Utilities 17.1M - OK
        MySQL-client-5.5.28-1.rhel5.i386.rpm
 
    Red Hat & Oracle Linux 5 (x86, 32-bit), RPM Package MySQL Server 52.2M
        MySQL-server-5.5.28-1.rhel5.i386.rpm
 
    Red Hat & Oracle Linux 5 (x86, 32-bit), RPM Package Shared components 1.9M - OK
       MySQL-shared-5.5.28-1.rhel5.i386.rpm
3. Jalankan semua package dengan perintah ---> rpm -Uvh namafile.rpm
4. Reboot Server
5. Jalankan perintah ini ----> /usr/bin/mysql_secure_installation
6. Ikuti perintah yang ada
7. Setting /etc/my.cnf menjadi
    [mysqld]
       datadir=/var/lib/mysql
       socket=/var/lib/mysql/mysql.sock
       user=mysql

       #remote
       pid-file = /var/run/mysqld/mysqld.pid
       port = 3306
       basedir = /usr
       datadir = /var/lib/mysql
       tmpdir = /tmp
       #bind-address = 10.200.16.17
       old_passwords=1
       [mysqld_safe]
       log-error=/var/log/mysqld.log
       pid-file=/var/run/mysqld/mysqld.pid
8. Setting Firewall dengan perintah :
       /sbin/iptables -I INPUT -p tcp --destination-port 3306 -j ACCEPT
    /sbin/iptables -I OUTPUT -p tcp --source-port 3306 -j ACCEPT
9. Simpan settingan iptables
    service iptables save  
  



Tidak ada komentar: