Category Archives: CentOS Server

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

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

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

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

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

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

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#