Mysql Problem, Operating system error number 13 in a file operation

Posted by cikul | Posted in Linux, SQL | Posted on 31-07-2017-05-2008


Mysql Fail to start, check in /var/log/mysqld.log :

170731 16:56:50 InnoDB: Initializing buffer pool, size = 8.0M
170731 16:56:50 InnoDB: Completed initialization of buffer pool
170731 16:56:50 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
170731 16:56:50 mysqld_safe mysqld from pid file /var/run/mysqld/ ended


Cause :

Permission problem in /var/lib/mysql

Solutions :

  1. Ensure user and group permission on /var/lib/mysql is mysql
  2. Check SELINUX Configuration : getenforce
  3. If SELINUX enabled, disabled with command : setenforce 0
  4. For permanent disable, edit /etc/selinux/config and set SELINUX=disabled
  5. Try to restart mysql service

Incoming search terms:

https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1820 vypjXIo9pXF2rJl0Z34E0NBkUuUeT__9D_sC-BV3pOKTc_kScptPQX7ZYlnOdJZR 24c2c6f41339ec5a8c6cad2f019cabac95e11af8&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme | https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1825 dEMiTyirfjpkgVHcSTPpSig3_0qN4pZlfCbvZftpI-orXgQjp_vz30cZNxXSycTN 0ebe5d9112c33e79fee5cc07a54805ce45836e48&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme | https://yandex ru/clck/jsredir?from=yandex ru;search;web;;&text=&etext=1831 gkspp4y112i5VL6Mx2eujlrS2hAiKkPive3YelfbGg2Z5NvqHJCSK0fMw80pieUJ f4fede99c49f3809eda71aea60a857d5a59c63de&uuid=&state=_BLhILn4SxNIvvL0W45KSic66uCIg23qh8iRG98qeIXme | 

Create Bootable CentOS USB from Mac OS

Posted by cikul | Posted in Linux, Mac OS | Posted on 22-06-2017-05-2008


Create img file from downloaded iso :

Fors-MacBook-Air:Downloads cikul$ hdiutil convert -format UDRW -o CentOS-69.img CentOS-6.9-x86_64-minimal.iso        
Reading CentOS_6.9_Final                 (Apple_ISO : 0)…
Reading  (Apple_Free : 1)…
Elapsed Time:  2.059s
Speed: 198.1Mbytes/sec
Savings: 0.0%
created: /Users/cikul/Downloads/CentOS-69.img.dmg

List All Devices, and umount USB before flashing new image

Fors-MacBook-Air:~ cikul$ diskutil list
/dev/disk0 (internal, physical):
   #:                       TYPE NAME                    SIZE       IDENTIFIER
   0:      GUID_partition_scheme                        *121.3 GB   disk0
   1:                        EFI EFI                     209.7 MB   disk0s1
   2:          Apple_CoreStorage For Sale                120.5 GB   disk0s2
   3:                 Apple_Boot Recovery HD             650.0 MB   disk0s3

/dev/disk1 (internal, virtual):
   #:                       TYPE NAME                    SIZE       IDENTIFIER
   0:                  Apple_HFS Dhika Cikul            +120.1 GB   disk1
                                 Logical Volume on disk0s2

/dev/disk2 (external, physical):
   #:                       TYPE NAME                    SIZE       IDENTIFIER
   0:     FDisk_partition_scheme                        *15.4 GB    disk2
   1:             Windows_FAT_32 NO NAME                 15.4 GB    disk2s1

Fors-MacBook-Air:~ cikul$ diskutil unmountDisk /dev/disk2
Unmount of all volumes on disk2 was successful

Use dd utility to copy the iso/img to USB Flash :

Fors-MacBook-Air:Downloads cikul$ time sudo dd if=CentOS-69.img.dmg of=/dev/disk2 bs=1m
408+0 records in
408+0 records out
427819008 bytes transferred in 120.542862 secs (3549103 bytes/sec)

real	2m3.909s
user	0m0.016s
sys	0m7.868s


Add Static Route Linux – Windows – Mac OS

Posted by cikul | Posted in Linux, Mac OS, Windows | Posted on 22-06-2017-05-2008


In Linux the command is :

route add -net gw

In Windows the command is :

route add mask

In Mac OS the command is :

route -n add -net

Fix CentOS USB Install Problem

Posted by cikul | Posted in Linux | Posted on 01-06-2016-05-2008


When installing CentOS using USB stick, i experienced problem with repository install after partition

Unable to read package metadata. This may be due to missing repodata directory. Please ensure that your install tree has been correctly generated. Failare: repodata/743fec56b2af0ce8d6ec82c47a4efafc2a4d18cddfa9683f29611cb18d1a33de-primary.sqlite.bz2 from anaconda-CentOS-201311271240.i386: [Ermo 256] No more mirrors to try.

The problem is because installer cannot found the file which described in repomd file located in /repodata folder

To fix the problem, go to /repodata folder on your usb stick, and change the file under repodata matched to the parameter configured in repomd file, for example :

in repomd location :

location href=”repodata/b124f0ec5323cfee56b420906a3103f0daef656dde3f7ac8220120aa7504e57a-primary.xml.gz”

so you must find the file under /repodata folder which matched with the configuration, and change the extension in accordance with the parameter configured in repomd file.

Change & Reset Mysql Password

Posted by cikul | Posted in Linux, SQL, Tips | Posted on 18-10-2015-05-2008


This tutorial explains how to change or reset your MySQL root password under Unix-Like Operating Systems (Linux, FreeBSD, OpenBSD, etc) over SSH. MySQL root account should be managed carefully.

As a system administrator, we must ensure that the password is safe and prevent from unauthorized access.

There are some method to change mysql password :

Type 1 : use mysqladmin

However, if you want to change mysql root/user password, mysql had tool to simplify the process using mysqladmin command, the syntax is :

$ mysqladmin -u root -p'oldpassword' password newpass
$ mysqladmin -u dbuser -p'oldpassword' password 'itsnewpassword';

Read the rest of this entry »

[CentOS] Merubah Gambar Background GRUB saat booting

Posted by cikul | Posted in Linux | Posted on 01-03-2015-05-2008


Gambar pada tampilan awal GRUB biasanya mengikuti distro linux yang kita gunakan, seperti contoh untuk CentOS maka Tampilan awal GRUB akan menampilkan gambar background dari CentOS seperti gambar berikut


Tampilan Splash Screen GRUB

sekarang bagaimana cara kita mengganti background image default tersebut?

Read the rest of this entry »

Completely Uninstall Kloxo-MR

Posted by cikul | Posted in cpanel, Free Stuff, Internet, Linux | Posted on 13-11-2014-05-2008


Based on my experience, it’s easy to find tutorial how to install Kloxo-MR, but hard to find tutorial how to uninstall Kloxo-MR, lack of documentation for Kloxo-MR make the installation of Kloxomr difficult for some system administrators.

If you had problem during kloxo-mr installation, the easy way to troubleshoot is recreate your VPS container, but if you won’t do that, you can reinstalling kloxo-mr from scratch, but make sure the system has clean from previous install to avoid problem.

Read the rest of this entry »

Record Shell Session in Linux

Posted by cikul | Posted in Linux | Posted on 03-12-2013-05-2008


Sometimes we need to log all activity we do in linux terminal. That is no problem if your terminal client had the feature, but if your terminal client don’t have feature to log your session, you can use “script” command record everything you do in a terminal session.

it’s very simple to use script, you only type this command from your shell

script -a filename

Now everything you type, as well as everything that returns as output, will be saved into the filename you chose to output to.

To stop script session, type “exit”, and script daemon will stop to recording your session

[root@server ]# exit
Script done

Incoming search terms:

acer z4 kaskus | 

Install MariaDB on CentOS

Posted by cikul | Posted in Linux | Posted on 28-11-2013-05-2008


MariaDB repositories doesn’t included by default on CentOS.
If you want to install MariaDB using YUM, you need to add MariaDB repository

nano /etc/yum.repos.d/MariaDB.repo

Read the rest of this entry »

[CentOS-RedHat] Linux /boot: Out of Disk Space While Installing Package kernel

Posted by cikul | Posted in Linux | Posted on 21-01-2013-05-2008


When updating Kernel using YUM, i got this error message :

Transaction Check Error:
  installing package kernel-2.6.32-379.14.1.lve1.1.9.9.el6.x86_64 needs 10MB on the /boot filesystem
Error Summary
Disk Requirements:
  At least 10MB more space needed on the /boot filesystem.

It means /boot partition is out of disk space. You need to verify this with the df command

Read the rest of this entry »