Change & Reset Mysql Password

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

0

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 »

Share and Enjoy

[CentOS] Merubah Gambar Background GRUB saat booting

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

0

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

grubCentOS

Tampilan Splash Screen GRUB

sekarang bagaimana cara kita mengganti background image default tersebut?

Read the rest of this entry »

Share and Enjoy

Completely Uninstall Kloxo-MR

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

1

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 »

Share and Enjoy

Record Shell Session in Linux

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

0

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
exit
Script done

Incoming search terms:

acer z4 kaskus | 

Share and Enjoy

Add multiple IP Address CentOS

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

0

In Linux, we can add more than 1 IP Address in single ethernet device. To adding more IP address we must add new IP in network device configuration file,


nano /etc/sysconfig/network-scripts/
 

Read the rest of this entry »

Share and Enjoy

Install MariaDB on CentOS

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

0

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 »

Share and Enjoy

[Linux] Find/search text in file under directory

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

0

To search text in file under directory/subdirectory, for example we want to find php file under /home directory contains text “eval” in the content, we can use command :


shell [~]# find /home/ -name "*".php -type f -print0| xargs -0 egrep "eval" | uniq -c | sort -u | cut -d":" -f1 | awk '{print "Warning - please check this files " $2}' | uniq > eval.log

Share and Enjoy

[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

0

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 »

Share and Enjoy

[Solaris] Check CPU Speed & Memory Size

Posted by cikul | Posted in Linux, Technology | Posted on 26-09-2012-05-2008

0

SUN OS based on UNIX, but has different structure with another linux system. For example in Linux, you can easily check CPU & Memory info using /proc/cpuinfo and /proc/meminfo, or you can check hardware information using lspci or dmidecode.

And how in SunOS?

Read the rest of this entry »

Share and Enjoy

[Oracle] Troubleshoot “Connected to an idle instance.”

Posted by cikul | Posted in Linux, Oracle, SQL, Windows | Posted on 24-09-2012-05-2008

0

Problem : You have an Oracle instance, and you know it’s running on the system, when you’re trying to connect using “/ as sysdba” it says the instance is idle. You know the database is up and opened, because your application’s talking to it.


[oracle@server db_1]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 24 15:22:47 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL>

Read the rest of this entry »

Share and Enjoy