Wednesday, December 8, 2010

Setup PHPMYADMIN guna yum

Smalam aku cuba nk install phpmyadmin dlm Centos..So dgn slambernyer aku guna command budak malas nk explore... #yum install phpmyadmin

so dgn slambernyer dia kuar error "No Repositories Available to Set Up ,Reading repository metadata in from local files, No Match for argument: phpmyadmin , Nothing to do"

kurang asam btul...lepas tu baru aku tahu nk ilmu kena banyak bertanya..so 1st step try tanya en Google...So nie dia nyer jawapan ::

  1. wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.1-1.el5.rf.i386.rpm
    rpm
    -Uhv rpmforge-release-0.5.1-1.el5.rf.i386.rpm
  2. yum install phpmyadmin

  3. vi /etc/httpd/conf.d/phpmyadmin.conf

    Just change the line “Allow from 127.0.0.1″ to “Allow from [yourip]“, where [yourip] is IP address of your computer if you have public static IP. Otherwise, you can also set it to “Allow from all”

  4. service httpd restart
  5. vi /usr/share/phpmyadmin/config.inc.php

    $cfg['blowfish_secret'] = 'mysecretpassphrase'; /* YOU MUST FILL IN THIS
    FOR
    COOKIE AUTH! */

  6. mysqladmin -u root password PASSWORD_HERE
Pastu dh setel install phpmyadmin, aku nk load dbase (import) ke server baru ni...Skali dia kata exceed limit....By default size dbase.sql yg dibenarkan oleh phpmyadmin adalah 2Mb..So nk besarkan size tu ko kena oter kat file php.ini dan cari upload_max_filesize. Ubah jer lah kat situ ikut kemahuan sanubari korang...Paling maximum aku xpernah try...

ok chows

Reference ::

http://www.khattam.info/howto-install-phpmyadmin-in-centos-5-2010-09-25.html
http://junal.wordpress.com/2007/10/03/increase-the-import-file-size-in-phpmyadmin/

No comments: