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

Query data from specific date SQL Server

Posted by cikul | Posted in SQL, Tips | Posted on 01-03-2012-05-2008

2

for example, you have sort of data from table order :

Order id Order_date Value
1 2005-12-15 13:04:42.667 500
2 2006-03-16 19:08:30.423 350
3 2007-07-28 15:14:30.350 400
4 2006-03-16 20:11:25.413 150
5 2000-09-10 16:09:58.817 200

and you want to get data for date 2006-03-16,

Read the rest of this entry »

Share and Enjoy

Timor Part Replacement – Pengganti part Timor

Posted by cikul | Posted in otomotif | Posted on 08-07-2011-05-2008

0

Bagi yang memiliki mobil Timor dan kesulitan mendapatkan beberapa part, berikut daftar part Timor yang dapat diganti (Kanibal) dengan part mobil lain.

  1. Kabel Busi DOHC pake kabel businya Mazda Familia
  2. Plat Kopling bisa pake Mazda Familia, L300 Bensin, Lancer, Feroza, KIA Rio
  3. HLA SOHC pake HLA Hyundai Getz
  4. Velg bisa pake velg Corolla All New, Honda City (PCD 100 & OFFSET 38 Ukuran Maksimum 19″Inch)
  5. Karet Dudukan Atas Shocbreaker Depan pake Mazda
  6. Distributor DOHC bisa pake Mitshubisi SS
  7. Karet Pemegang Stearing Shaft bisa pake Mazda\
  8. Shocbreaker Belakang bisa pake Kayaba Gas atau Olie
  9. Per Belakang bisa pake Great Corolla
  10. Radiator bisa pake Honda Accord
  11. Bearing Roda Belakang bisa pakai punya Madza 323, HUB053-70 (NSK) HUB053-73 (NTN)
  12. Busi bisa pakai Toyota Inova
  13. KUL Stater/Carbon/Arang Staternya bisa pake L-300 Bensin
  14. Oli Mesin (Ref) pake SAE 10-40W
  15. Oli Transmisi Multigrade SAE 75-90W
  16. Packing klep timor sohc sama dengan mazda interplay, yang DOHC sama dengan Ford new laser ghia injection 1.6cc/familia 1.6cc
  17. Sealklep timor SOHC sama dengan 626 capela, dohc dengan Hyundai accen dan mazda familia
  18. HLA (adjuster) SOHC sama dengan Hyundai accent, Dohc sama dengan hampir semua mazda injection yang th 90an.

Read the rest of this entry »

Incoming search terms:

spare part timor | sparepart timor | 

Share and Enjoy

How To Root Huawei Ideos C8150 / AHA Touch

Posted by cikul | Posted in Android, Tips | Posted on 08-02-2011-05-2008

7

Huawei launched the first Android HP to market that is named Ideos and embedded Android 2.2 Froyo as in his system. Ideos appears to specifications measuring 2.8 inch touchscreen, HSDPA / EVDO, GPS, Wi-Fi 802.11n, 3.2MP camera, and 528MHz processor.

This tutorial explains how to gain root access on the device Ideos Huawei C8150.

Read the rest of this entry »

Incoming search terms:

root aha Touch | aha touch | upgrade aha touch | 

Share and Enjoy

Repair Write Protected Flash Disk

Posted by cikul | Posted in Tips | Posted on 06-01-2011-05-2008

0

Write protected disk problem arises because the flash disk immediately revoked without “safely removed hardware”

To fix this, there are several ways :

1.  Using Registry

  • Start > Run > type ‘regedit’ then hit ‘OK’.
  • Browse to the following key:
  • My Computer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlS et\Control\StorageDevicePolicies
  • Double click on the string ‘WriteProtect’ and change the ‘Value Data’ box to ‘0’
  • You may also need to do this for the strings in any folders called ‘ControlSet***’ e.g.
  • My Computer\HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\C ontrol\StorageDevicePolicies

Read the rest of this entry »

Incoming search terms:

flash disk | flashdisk | gambar flashdisk | gambar flash disk | flash disc | flashdisk kingston | flashdisk kingstone | flashdisk kingstone write protected | Kingston Flashdisk | gambar-gambar flashdisk | 

Share and Enjoy

WordPress WAP Mobile Support

Posted by cikul | Posted in Tips, wordpress | Posted on 10-11-2010-05-2008

0

This Site is now support mobile/WAP browser, if you access this site from your mobile/WAP browser, the themes will automatically switch to Wap Themes.

This Features using WPTap Plugin for detecting mobile browsers and Carrington Mobile for the theme.

Share and Enjoy

How To Access OpenVPN using Windows, Linux, MAC OS X and Windows Mobile for Pocket PC

Posted by cikul | Posted in Free Stuff, Freeware, Linux, Technology, Tips, Windows | Posted on 10-11-2010-05-2008

8

The purpose of this document is to lead the users to configure theirs OpenVPN clients to access to a VPN server. We will see how to install and configure the most used OpenVPN’s GUI for Microsoft Windows, Linux, Mac OS X and Windows Mobile for Pocket PC. At the end of the document we will learn to use the OpenVPN’s command line interface. This last possibility is useful, because the openvpn command, which you can execute by using the prompt (Unix Shell or Windows Prompt) accepts the same parameters and has the same behavior regardless from which Operating System you use. In addition, you could use the openvpn command in a script to automatically start the VPN connection.

Read the rest of this entry »

Incoming search terms:

JAK SPRAWDZI PING | 

Share and Enjoy

Unable to add Gmail or Google Apps Account to Blackberry

Posted by cikul | Posted in Internet, Tips | Posted on 26-10-2010-05-2008

0

Are you having problems with email on your blackberry when you change your email password in GMAIL?

To fix this, Do the following on your computer and then once unlocked you will be able to set up on blackberry :

  • Disable all mail clients you’re using to read Gmail messages. (If you use one at work and one at home, please disable both.)
  • visit http://www.google.com/accounts/DisplayUnlockCaptcha
  • Enter your Gmail username and password, and the letters in the distorted picture.
  • Once you have successfully logged in, restart your mail client and try to download your mail.

Ahis applies also to the email using Google Apps

Share and Enjoy

Tips : Remove uninstalled list in Blackberry app world

Posted by cikul | Posted in Tips | Posted on 03-08-2010-05-2008

4

If you have uninstalled application using bb application world, Blackberry still save your list there with tag uninstall. It can be disturb by some users like me. Try to remove using BB menu but the option is unavailabe.

To remove uninstalled list from your Blackberry app world you can go to the application (bb apps) then press alt+R+S+T. Hold alt key then press R+S+T one by one.

For Storm/Pearl — Hold the num-lock (!?123) button so it locks and then press, in sequence 3, then 4, then (

if they do not succeed, try following these steps :

  1. uninstall the app from AppWorld
  2. check that is is really uninstalled in the “manage applications”
  3. start the install the app through AppWorld
  4. cancel the installation
  5. do a battery pull

Incoming search terms:

how to delete uninstalled apps on blackberry app world | how to remove uninstalled apps from blackberry | 

Share and Enjoy

Macam-macam socket wiper mobil

Posted by cikul | Posted in otomotif | Posted on 01-04-2010-05-2008

0

Wiper menjadi sangat penting terutama jika hujan mengguyur. Karena wiper berguna untuk membersihkan kaca dari guyuran air hujan dan mengurangi embun yang menempel di kaca depan. Sehingga Anda masih tetap dapat menatap pandangan ke kaca depan tanpa terganggu oleh guyuran air hujan.

Jika anda merasa wiper di mobil anda sudah waktunya untuk diganti, anda harus mengetahui tipe socket wiper di mobil anda, karena apabila anda salah membeli, wiper yang anda beli akan menjadi percuma, karena tidak dapat dipasang di mobil anda.

Berikut macam-macam socket wiper mobil :
Read the rest of this entry »

Incoming search terms:

WIPER MOBIL | macam-macam socket | 

Share and Enjoy