Category Archives: CentOS Server

Mengatasi Error phpMyAdmin: Cannot start session without errors pada php-fpm

March 27, 2023

Pagi ini saya baru saja menginstall php-fpm dan phpMyAdmin dari repositori remi/epel/rpmfusion. Namun, ketika saya membuka halaman phpMyAdmin, saya menemukan pesan error sebagai berikut:

phpMyAdmin – Error

Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

Sepertinya error tersebut disebabkan oleh PHP yang tidak dapat menulis session karena adanya masalah dengan keberadaan dan izin pada direktori /var/lib/php/session.

Lalu, bagaimana cara mengatasinya? Berikut solusinya:

  1. Buka file /etc/php.ini dan ganti: 
    ;session.save_path = "/tmp"

    menjadi:

    session.save_path = /var/lib/php/session
  2. Restart php-fpm dengan perintah: 
    service php-fpm restart

    dan buka phpMyAdmin menggunakan browser atau profil yang berbeda.

  3. Jika cara di atas tidak berhasil, lakukan langkah-langkah berikut:
mkdir /var/lib/php/session
chmod 777 /var/lib/php/session

Lalu, restart php-fpm dengan perintah:

service php-fpm restart

Alhamdulillah, setelah menggunakan cara tersebut, saya dapat mengakses phpMyAdmin dengan normal.

Cara Install gtk-3 di Centos 6 64bit

April 25, 2017

Posting ini belum selesai

Jujur saja hingga saat saya menulis post ini, rasanya masih enggan untuk upgrade Centos versi terbaru, saya sudah merasa nyaman masih setia menggunakan Centos 6 baik di server atau desktop. Seiring berjalannya waktu centos 6 ini terlihat tua dan renta, apalagi saat ini telah dirilis centos 8 dengan berbagai keanggunan dan kecantikan tampilannya yang menggunakan gnome terbaru, sangat wajar jika banyak orang dan developer lebih memilih mengikuti perkembangan jaman dengan meninggalkan centos 6.

Tidak dengan saya. Saya lebih memilih menambal secara manual berbagai ketertinggalan Centos 6. Satu persatu masalah muncul salah satunya Centos 6 tidak bisa menjalankan firefox terbaru, hal ini karena di dalam Centos 6 kita tidak bisa menginstall library gtk-3 yang diperlukan untuk menjalankan mozilla.

Lalu bagaimana solusinya? mari kita simak langkah sederhana dibawah ini

 

#repo ini bisa diganti dengan server yang terdekat atau lebih stabil wget https://repo.ugm.ac.id/centos/6.9/os/x86_64/Packages/centos-release-6-9.el6.12.3.x86_64.rpm croot=/tmp/CentOS mkdir -p $croot $croot/proc $croot/dev mount -o bind /dev $croot/dev mount -o bind /dev/pts $croot/dev/pts mount -o bind /proc $croot/proc rpm -ivh --root $croot centos-release*.rpm yum --installroot=$croot install gcc make bison rpm-build expat-devel \   fontpackages-devel gcc-c++ libtool bash mc yum freetype-devel tar which gettext \   libXext-devel libXrender-devel libXi-devel libpng-devel libjpeg-turbo-devel \   libtiff-devel perl-XML-Parser flex libxml2-devel popt-devel libXtst-devel -y chroot $croot

Tunggu beberapa lama prosesnya akan memerlukan bandwidth sekitar 150MB. Dalam instalasi ini file yang diinstall terlihat di list berikut ini

  bash.x86_64 0:4.1.2-48.el6                                                       bison.x86_64 0:2.4.1-5.el6                                                       expat-devel.x86_64 0:2.0.1-13.el6_8                                              flex.x86_64 0:2.5.35-9.el6                                                       fontpackages-devel.noarch 0:1.41-1.1.el6                                         freetype-devel.x86_64 0:2.3.11-17.el6                                            gcc.x86_64 0:4.4.7-18.el6                                                        gcc-c++.x86_64 0:4.4.7-18.el6                                                    gettext.x86_64 0:0.17-18.el6                                                     libXext-devel.x86_64 0:1.3.3-1.el6                                               libXi-devel.x86_64 0:1.7.8-1.el6                                                 libXrender-devel.x86_64 0:0.9.10-1.el6                                           libXtst-devel.x86_64 0:1.2.3-1.el6                                               libjpeg-turbo-devel.x86_64 0:1.2.1-3.el6_5                                       libpng-devel.x86_64 2:1.2.49-2.el6_7                                             libtiff-devel.x86_64 0:3.9.4-21.el6_8                                            libtool.x86_64 0:2.2.6-15.5.el6                                                  libxml2-devel.x86_64 0:2.7.6-21.el6_8.1                                          make.x86_64 1:3.81-23.el6                                                        mc.x86_64 1:4.7.0.2-6.el6                                                        perl-XML-Parser.x86_64 0:2.36-7.el6                                              popt-devel.x86_64 0:1.13-7.el6                                                   rpm-build.x86_64 0:4.8.0-55.el6                                                  tar.x86_64 2:1.23-15.el6_8                                                       which.x86_64 0:2.19-6.el6                                                        yum.noarch 0:3.2.29-81.el6.centos                                              Dependency Installed:   MAKEDEV.x86_64 0:3.24-6.el6                                                      audit-libs.x86_64 0:2.4.5-6.el6                                                  autoconf.noarch 0:2.63-5.1.el6                                                   automake.noarch 0:1.11.1-4.el6                                                   basesystem.noarch 0:10.0-4.el6                                                   binutils.x86_64 0:2.20.51.0.2-5.47.el6_9.1                                       bzip2.x86_64 0:1.0.5-7.el6_0                                                     bzip2-libs.x86_64 0:1.0.5-7.el6_0                                                ca-certificates.noarch 0:2016.2.10-65.4.el6                                      checkpolicy.x86_64 0:2.0.22-1.el6                                                chkconfig.x86_64 0:1.3.49.5-1.el6                                                cloog-ppl.x86_64 0:0.15.7-1.2.el6                                                coreutils.x86_64 0:8.4-46.el6                                                    coreutils-libs.x86_64 0:8.4-46.el6                                               cpio.x86_64 0:2.10-13.el6                                                        cpp.x86_64 0:4.4.7-18.el6                                                        cracklib.x86_64 0:2.8.16-4.el6                                                   cracklib-dicts.x86_64 0:2.8.16-4.el6                                             curl.x86_64 0:7.19.7-53.el6_9                                                    cvs.x86_64 0:1.11.23-16.el6                                                      cyrus-sasl-lib.x86_64 0:2.1.23-15.el6_6.2                                        db4.x86_64 0:4.7.25-22.el6                                                       db4-utils.x86_64 0:4.7.25-22.el6                                                 dbus-glib.x86_64 0:0.86-6.el6                                                    dbus-libs.x86_64 1:1.2.24-8.el6_6                                                diffutils.x86_64 0:2.8.1-28.el6                                                  elfutils.x86_64 0:0.164-2.el6                                                    elfutils-libelf.x86_64 0:0.164-2.el6                                             elfutils-libs.x86_64 0:0.164-2.el6                                               ethtool.x86_64 2:3.5-6.el6                                                       expat.x86_64 0:2.0.1-13.el6_8                                                    fakeroot.x86_64 0:1.12.2-22.2.el6                                                fakeroot-libs.x86_64 0:1.12.2-22.2.el6                                           file.x86_64 0:5.04-30.el6                                                        file-libs.x86_64 0:5.04-30.el6                                                   filesystem.x86_64 0:2.4.30-3.el6                                                 findutils.x86_64 1:4.4.2-9.el6                                                   fontconfig.x86_64 0:2.8.0-5.el6                                                  fontpackages-filesystem.noarch 0:1.41-1.1.el6                                    freetype.x86_64 0:2.3.11-17.el6                                                  gamin.x86_64 0:0.1.10-9.el6                                                      gawk.x86_64 0:3.1.7-10.el6_7.3                                                   gdb.x86_64 0:7.2-92.el6                                                          gdbm.x86_64 0:1.8.0-39.el6                                                       glib2.x86_64 0:2.28.8-9.el6                                                      glibc.x86_64 0:2.12-1.209.el6_9.1                                                glibc-common.x86_64 0:2.12-1.209.el6_9.1                                         glibc-devel.x86_64 0:2.12-1.209.el6_9.1                                          glibc-headers.x86_64 0:2.12-1.209.el6_9.1                                        gmp.x86_64 0:4.3.1-12.el6                                                        gnupg2.x86_64 0:2.0.14-8.el6                                                     gpgme.x86_64 0:1.1.8-3.el6                                                       gpm-libs.x86_64 0:1.20.6-12.el6                                                  grep.x86_64 0:2.20-6.el6                                                         groff.x86_64 0:1.18.1.4-21.el6                                                   gzip.x86_64 0:1.3.12-24.el6                                                      hwdata.noarch 0:0.233-18.1.el6                                                   info.x86_64 0:4.13a-8.el6                                                        initscripts.x86_64 0:9.03.58-1.el6.centos                                        iproute.x86_64 0:2.6.32-54.el6                                                   iptables.x86_64 0:1.4.7-16.el6                                                   iputils.x86_64 0:20071127-24.el6                                                 kernel-headers.x86_64 0:2.6.32-696.1.1.el6                                       keyutils-libs.x86_64 0:1.4-5.el6                                                 krb5-libs.x86_64 0:1.10.3-65.el6                                                 less.x86_64 0:436-13.el6                                                         libX11.x86_64 0:1.6.4-3.el6                                                      libX11-common.noarch 0:1.6.4-3.el6                                               libX11-devel.x86_64 0:1.6.4-3.el6                                                libXau.x86_64 0:1.0.6-4.el6                                                      libXau-devel.x86_64 0:1.0.6-4.el6                                                libXext.x86_64 0:1.3.3-1.el6                                                     libXfixes.x86_64 0:5.0.3-1.el6                                                   libXfixes-devel.x86_64 0:5.0.3-1.el6                                             libXi.x86_64 0:1.7.8-1.el6                                                       libXrender.x86_64 0:0.9.10-1.el6                                                 libXtst.x86_64 0:1.2.3-1.el6                                                     libacl.x86_64 0:2.2.49-7.el6                                                     libattr.x86_64 0:2.4.44-7.el6                                                    libblkid.x86_64 0:2.17.2-12.28.el6                                               libcap.x86_64 0:2.16-5.5.el6                                                     libcom_err.x86_64 0:1.41.12-23.el6                                               libcurl.x86_64 0:7.19.7-53.el6_9                                                 libdrm.x86_64 0:2.4.65-2.el6                                                     libffi.x86_64 0:3.0.5-3.2.el6                                                    libgcc.x86_64 0:4.4.7-18.el6                                                     libgcrypt.x86_64 0:1.4.5-12.el6_8                                                libgomp.x86_64 0:4.4.7-18.el6                                                    libgpg-error.x86_64 0:1.7-4.el6                                                  libidn.x86_64 0:1.18-2.el6                                                       libjpeg-turbo.x86_64 0:1.2.1-3.el6_5                                             libnih.x86_64 0:1.0.1-7.el6                                                      libpciaccess.x86_64 0:0.13.4-1.el6                                               libpng.x86_64 2:1.2.49-2.el6_7                                                   libselinux.x86_64 0:2.0.94-7.el6                                                 libselinux-utils.x86_64 0:2.0.94-7.el6                                           libsemanage.x86_64 0:2.0.43-5.1.el6                                              libsepol.x86_64 0:2.0.41-4.el6                                                   libssh2.x86_64 0:1.4.2-2.el6_7.1                                                 libstdc++.x86_64 0:4.4.7-18.el6                                                  libstdc++-devel.x86_64 0:4.4.7-18.el6                                            libtasn1.x86_64 0:2.3-6.el6_5                                                    libtiff.x86_64 0:3.9.4-21.el6_8                                                  libusb.x86_64 0:0.1.12-23.el6                                                    libutempter.x86_64 0:1.1.5-4.1.el6                                               libuuid.x86_64 0:2.17.2-12.28.el6                                                libxcb.x86_64 0:1.12-4.el6                                                       libxcb-devel.x86_64 0:1.12-4.el6                                                 libxml2.x86_64 0:2.7.6-21.el6_8.1                                                lua.x86_64 0:5.1.4-4.1.el6                                                       m4.x86_64 0:1.4.13-5.el6                                                         mailcap.noarch 0:2.1.31-2.el6                                                    man.x86_64 0:1.6f-39.el6                                                         mingetty.x86_64 0:1.08-5.el6                                                     module-init-tools.x86_64 0:3.9-26.el6                                            mpfr.x86_64 0:2.4.1-6.el6                                                        ncurses.x86_64 0:5.7-4.20090207.el6                                              ncurses-base.x86_64 0:5.7-4.20090207.el6                                         ncurses-libs.x86_64 0:5.7-4.20090207.el6                                         net-tools.x86_64 0:1.60-114.el6                                                  nspr.x86_64 0:4.13.1-1.el6                                                       nss.x86_64 0:3.28.4-1.el6_9                                                      nss-softokn.x86_64 0:3.14.3-23.3.el6_8                                           nss-softokn-freebl.x86_64 0:3.14.3-23.3.el6_8                                    nss-sysinit.x86_64 0:3.28.4-1.el6_9                                              nss-tools.x86_64 0:3.28.4-1.el6_9                                                nss-util.x86_64 0:3.28.4-1.el6_9                                                 openldap.x86_64 0:2.4.40-16.el6                                                  openssl.x86_64 0:1.0.1e-57.el6                                                   p11-kit.x86_64 0:0.18.5-2.el6_5.2                                                p11-kit-trust.x86_64 0:0.18.5-2.el6_5.2                                          pam.x86_64 0:1.1.1-24.el6                                                        patch.x86_64 0:2.6-6.el6                                                         pcre.x86_64 0:7.8-7.el6                                                          perl.x86_64 4:5.10.1-144.el6                                                     perl-Compress-Raw-Zlib.x86_64 1:2.021-144.el6                                    perl-Compress-Zlib.x86_64 0:2.021-144.el6                                        perl-HTML-Parser.x86_64 0:3.64-2.el6                                             perl-HTML-Tagset.noarch 0:3.20-4.el6                                             perl-IO-Compress-Base.x86_64 0:2.021-144.el6                                     perl-IO-Compress-Zlib.x86_64 0:2.021-144.el6                                     perl-Module-Pluggable.x86_64 1:3.90-144.el6                                      perl-Pod-Escapes.x86_64 1:1.04-144.el6                                           perl-Pod-Simple.x86_64 1:3.13-144.el6                                            perl-URI.noarch 0:1.40-2.el6                                                     perl-libs.x86_64 4:5.10.1-144.el6                                                perl-libwww-perl.noarch 0:5.833-5.el6                                            perl-version.x86_64 3:0.77-144.el6                                               pinentry.x86_64 0:0.7.6-8.el6                                                    pkgconfig.x86_64 1:0.23-9.1.el6                                                  plymouth.x86_64 0:0.8.3-29.el6.centos                                            plymouth-core-libs.x86_64 0:0.8.3-29.el6.centos                                  plymouth-scripts.x86_64 0:0.8.3-29.el6.centos                                    policycoreutils.x86_64 0:2.0.83-30.1.el6_8                                       popt.x86_64 0:1.13-7.el6                                                         ppl.x86_64 0:0.10.2-11.el6                                                       procps.x86_64 0:3.2.8-45.el6                                                     psmisc.x86_64 0:22.6-24.el6                                                      pth.x86_64 0:2.0.7-9.3.el6                                                       pygpgme.x86_64 0:0.1-18.20090824bzr68.el6                                        python.x86_64 0:2.6.6-66.el6_8                                                   python-iniparse.noarch 0:0.3.1-2.1.el6                                           python-libs.x86_64 0:2.6.6-66.el6_8                                              python-pycurl.x86_64 0:7.19.0-9.el6                                              python-urlgrabber.noarch 0:3.9.1-11.el6                                          readline.x86_64 0:6.0-4.el6                                                      redhat-logos.noarch 0:60.0.14-12.el6.centos                                      redhat-rpm-config.noarch 0:9.0.3-51.el6.centos                                   rpm.x86_64 0:4.8.0-55.el6                                                        rpm-libs.x86_64 0:4.8.0-55.el6                                                   rpm-python.x86_64 0:4.8.0-55.el6                                                 rpmdevtools.noarch 0:7.5-2.el6                                                   sed.x86_64 0:4.2.1-10.el6                                                        setup.noarch 0:2.8.14-23.el6                                                     shadow-utils.x86_64 2:4.1.5.1-5.el6                                              shared-mime-info.x86_64 0:0.70-6.el6                                             slang.x86_64 0:2.2.1-1.el6                                                       sqlite.x86_64 0:3.6.20-1.el6_7.2                                                 sysvinit-tools.x86_64 0:2.87-6.dsf.el6                                           tzdata.noarch 0:2017b-1.el6                                                      udev.x86_64 0:147-2.73.el6_8.2                                                   unzip.x86_64 0:6.0-5.el6                                                         upstart.x86_64 0:0.6.5-16.el6                                                    ustr.x86_64 0:1.0.4-9.1.el6                                                      util-linux-ng.x86_64 0:2.17.2-12.28.el6                                          vim-minimal.x86_64 2:7.4.629-5.el6_8.1                                           wget.x86_64 0:1.12-10.el6                                                        xorg-x11-proto-devel.noarch 0:7.7-14.el6                                         xz.x86_64 0:4.999.9-0.5.beta.20091007git.el6                                     xz-libs.x86_64 0:4.999.9-0.5.beta.20091007git.el6                                xz-lzma-compat.x86_64 0:4.999.9-0.5.beta.20091007git.el6                         yum-metadata-parser.x86_64 0:1.1.2-16.el6                                        yum-plugin-fastestmirror.noarch 0:1.1.30-40.el6                                  zlib.x86_64 0:1.2.3-29.el6                                                       zlib-devel.x86_64 0:1.2.3-29.el6

Tes Performa Server Menggunakan Apache Benchmarking

January 25, 2015

ab -c 1 -n 100 https://www.rahmatriyanto.com/

[rahmatriyanto@rahmatriyanto-centos6 ~]$ ab -c 1 -n 100 https://www.rahmatriyanto.com/ This is ApacheBench, Version 2.3 <$Revision: 655654 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, zeustech.net/ Licensed to The Apache Software Foundation, apache.org/ Benchmarking localhost (be patient).....done Server Software:        Nginx Server Hostname:        localhost Server Port:            80 Document Path:          / Document Length:        31698 bytes Concurrency Level:      1 Time taken for tests:   26.170 seconds Complete requests:      100 Failed requests:        0 Write errors:           0 Total transferred:      3190000 bytes HTML transferred:       3169800 bytes Requests per second:    3.82 [#/sec] (mean) Time per request:       261.701 [ms] (mean) Time per request:       261.701 [ms] (mean, across all concurrent requests) Transfer rate:          119.04 [Kbytes/sec] received Connection Times (ms)               min  mean[+/-sd] median   max Connect:        0    0   0.0      0       0 Processing:   248  262  11.8    260     324 Waiting:      201  214  11.7    211     276 Total:        248  262  11.8    260     324 Percentage of the requests served within a certain time (ms)   50%    260   66%    263   75%    265   80%    265   90%    269   95%    276   98%    310   99%    324  100%    324 (longest request) [rahmatriyanto@rahmatriyanto-centos6 ~]$

Solusi Can’t create database (errno: 13) pada MySQL

January 5, 2015

Secara default data mysql tersimpan di /var/lib/mysql , namun karena alasan kemudahan backup dan kapasitas saya mengubahnya di partisi lain yang termount di /mysqldata/. Untuk keperluan tersebut saya menjalankan perintah berikut:

sed -i 's/datadir=\/var\/lib\/mysql/datadir=\/ripanel\/mysqldata/g' /etc/my.cnf mkdir -p /mysqldata /etc/init.d/mysqld stop cp -rap /var/lib/mysql/* /mysqldata chown mysql.mysql /mysqldata  /etc/init.d/mysqld start

» Read more

Cara Mengaktifkan Permalink WordPress pada Server Nginx

December 26, 2014

Cara mengaktifkan permalink pada WordPress di server Nginx bisa menjadi sedikit berbeda dengan menggunakan server lain seperti Apache. Nginx memiliki struktur konfigurasi yang berbeda, sehingga ada beberapa langkah yang harus dilakukan untuk mengaktifkan permalink pada WordPress di server Nginx.

Langkah pertama adalah dengan mencari dan membuka file nginx.conf melalui terminal atau SSH. File ini biasanya terletak di direktori /etc/nginx/nginx.conf. Setelah itu, Anda perlu menambahkan konfigurasi berikut pada file tersebut:

 location / { try_files $uri $uri/ /index.php$is_args$args; }

Konfigurasi ini berfungsi untuk mengaktifkan semacam .htaccess pada server Nginx sehingga WordPress dapat menggunakan permalink. Kemudian, Anda perlu menyimpan perubahan dan menjalankan perintah reload untuk memuat ulang konfigurasi Nginx:

 sudo service nginx reload

Cara Install MySQL 5 di Debian

December 26, 2014

Kali ini saya install MySQL 5

Caranya sangat mudah menggunakan apt-get dari terminal

sudo apt-get install mysql-server

Tampilan prosesnya seperti ini:

rahmatriyanto@debian6:~$ su Password:  root@debian6:/home/rahmatriyanto# sudo apt-get install mysql-server Reading package lists... Done Building dependency tree        Reading state information... Done The following extra packages will be installed:   libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16   libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-common   mysql-server-5.1 mysql-server-core-5.1 Suggested packages:   libipc-sharedcache-perl libterm-readkey-perl tinyca The following NEW packages will be installed:   libdbd-mysql-perl libdbi-perl libhtml-template-perl libmysqlclient16   libnet-daemon-perl libplrpc-perl mysql-client-5.1 mysql-common mysql-server   mysql-server-5.1 mysql-server-core-5.1 0 upgraded, 11 newly installed, 0 to remove and 228 not upgraded. Need to get 22.2 MB/23.3 MB of archives. After this operation, 54.7 MB of additional disk space will be used. Do you want to continue [Y/n]? y Get:1 https://security.debian.org/ squeeze/updates/main mysql-common all 5.1.73-1 [71.2 kB] Get:2 https://security.debian.org/ squeeze/updates/main libmysqlclient16 i386 5.1.73-1 [1,927 kB] Get:3 https://security.debian.org/ squeeze/updates/main mysql-client-5.1 i386 5.1.73-1 [9,615 kB] Media change: please insert the disc labeled                                     'Debian GNU/Linux 6.0.3 _Squeeze_ - Official i386 DVD Binary-1 20111008-13:01' in the drive '/media/cdrom/' and press enter Media change: please insert the disc labeled                                     'Debian GNU/Linux 6.0.3 _Squeeze_ - Official i386 DVD Binary-1 20111008-13:01' in the drive '/media/cdrom/' and press enter Media change: please insert the disc labeled                                     'Debian GNU/Linux 6.0.3 _Squeeze_ - Official i386 DVD Binary-1 20111008-13:01' in the drive '/media/cdrom/' and press enter Get:4 https://security.debian.org/ squeeze/updates/main mysql-server-core-5.1 i386 5.1.73-1 [3,955 kB] Get:5 https://security.debian.org/ squeeze/updates/main mysql-server-5.1 i386 5.1.73-1 [6,543 kB] Get:6 https://security.debian.org/ squeeze/updates/main mysql-server all 5.1.73-1 [65.7 kB] Fetched 22.2 MB in 4min 1s (91.8 kB/s)                                          Preconfiguring packages ... Selecting previously deselected package mysql-common. (Reading database ... 127614 files and directories currently installed.) Unpacking mysql-common (from .../mysql-common_5.1.73-1_all.deb) ... Selecting previously deselected package libnet-daemon-perl. Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.43-1_all.deb) ... Selecting previously deselected package libplrpc-perl. Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ... Selecting previously deselected package libdbi-perl. Unpacking libdbi-perl (from .../libdbi-perl_1.612-1_i386.deb) ... Selecting previously deselected package libmysqlclient16. Unpacking libmysqlclient16 (from .../libmysqlclient16_5.1.73-1_i386.deb) ... Selecting previously deselected package libdbd-mysql-perl. Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.016-1_i386.deb) ... Selecting previously deselected package mysql-client-5.1. Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.73-1_i386.deb) ... Selecting previously deselected package mysql-server-core-5.1. Unpacking mysql-server-core-5.1 (from .../mysql-server-core-5.1_5.1.73-1_i386.deb) ... Processing triggers for man-db ... Setting up mysql-common (5.1.73-1) ... Selecting previously deselected package mysql-server-5.1. (Reading database ... 127990 files and directories currently installed.) Unpacking mysql-server-5.1 (from .../mysql-server-5.1_5.1.73-1_i386.deb) ... Selecting previously deselected package libhtml-template-perl. Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-2_all.deb) ... Selecting previously deselected package mysql-server. Unpacking mysql-server (from .../mysql-server_5.1.73-1_all.deb) ... Processing triggers for man-db ... Setting up libnet-daemon-perl (0.43-1) ... Setting up libplrpc-perl (0.2020-2) ... Setting up libdbi-perl (1.612-1) ... Setting up libmysqlclient16 (5.1.73-1) ... Setting up libdbd-mysql-perl (4.016-1) ... Setting up mysql-client-5.1 (5.1.73-1) ... Setting up mysql-server-core-5.1 (5.1.73-1) ... Setting up mysql-server-5.1 (5.1.73-1) ... Stopping MySQL database server: mysqld. 141225  5:39:06 [Note] Plugin 'FEDERATED' is disabled. 141225  5:39:06  InnoDB: Initializing buffer pool, size = 8.0M 141225  5:39:06  InnoDB: Completed initialization of buffer pool 141225  5:39:06  InnoDB: Started; log sequence number 0 44233 141225  5:39:06  InnoDB: Starting shutdown... 141225  5:39:12  InnoDB: Shutdown completed; log sequence number 0 44233 Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables.. Setting up libhtml-template-perl (2.9-2) ... Setting up mysql-server (5.1.73-1) ... root@debian6:/home/rahmatriyanto#

Setelah proses install selesai untuk mejalankan MySQL gunakancara berikut:

root@debian6:/home/rahmatriyanto# /etc/init.d/mysql start  Starting MySQL database server: mysqld.  Checking for corrupt, not cleanly closed and upgrade needing tables..  root@debian6:/home/rahmatriyanto# /etc/init.d/mysql restart  Stopping MySQL database server: mysqld.  Starting MySQL database server: mysqld.  Checking for corrupt, not cleanly closed and upgrade needing tables..  root@debian6:/home/rahmatriyanto# /etc/init.d/mysql reload  Reloading MySQL database server: mysqld.  root@debian6:/home/rahmatriyanto# /etc/init.d/mysql force-reload  Reloading MySQL database server: mysqld.  root@debian6:/home/rahmatriyanto# /etc/init.d/mysql status  /usr/bin/mysqladmin Ver 8.42 Distrib 5.1.73, for debian-linux-gnu on i486  Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its  affiliates. Other names may be trademarks of their respective  owners. Server version 5.1.73-1  Protocol version 10  Connection Localhost via UNIX socket  UNIX socket /var/run/mysqld/mysqld.sock  Uptime: 31 sec Threads: 1 Questions: 104 Slow queries: 0 Opens: 99 Flush tables: 1 Open tables: 23 Queries per second avg: 3.354.  root@debian6:/home/rahmatriyanto# /etc/init.d/mysql stop  Stopping MySQL database server: mysqld.  root@debian6:/home/rahmatriyanto#