Setting PATH for MYSQL bin


Yes, that thing come to my mind when I playing around with MYSQL.

Before setting PATH :

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd c:\wamp\bin\mysql\mysql5.1.36\bin

C:\wamp\bin\mysql\mysql5.1.36\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.36-community-log MySQL Community Server (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> exit

read more »

Preparing ubuntu usb install for nettop installation

Due to budget limitation and energy saving campaign in my office we try to explore more machine for our sms gateway. The criteria for this low traffic machine is clear :

Lowest energy with high storage facility and price within the range $100 – $250


Search in the net give me a few result around mini pc aka netttop
like :

  1. Asus EeeBox EBXB202-BLK-X0081
  2. Acer AspireRevo AR1600-U910H
  3. QutePC-1000

Operating System

I have experience with ubuntu as operating system and more than one device for gammu.

Little problem came when I realize that install method available for this nettop stuff is via usb.

Searching with google for ubuntu usb install, live usb linux, bootable usb, bootable usb linux and install linux from usb give me hint for visit Lili USB Creator. Fortunately this tool run in Windows :-)

read more »

Step by step Install Pure-FTP inside pfSense

pfSense is great stuff when you’re looking for Firewall but I need more :-)

Case :

A user want to store his file in the form of FTP but pfSense is the only server that available in the office. New HDD ready to support this method.

Solution : Add new HDD and install FTP server inside pfSense.

Steps : ( I use vmware for reproduction the steps)

Install pfSense version 1.2.3

1. Install pfSense

I install version 1.2.3 as I need to produce it with latest pfSense version.

install ftp server on pfsense : create virtual machine

I use 2 HDD ( system located in 8G HDD and second HDD for FTP data)

Ethernet 1 set for LAN ( ip address and ethernet 2 work as WAN ( I set to DHCP)

Enable sshd for remote configuration via ssh client like putty, securecrt  etc.

Restart system after successfully install to HDD.

read more »

Step by step Install Ubuntu Server 9.10

Step by step guide install Ubuntu Server 9.10 :

1. Download latest iso file or request free ubuntu CD from shipit.

2. Insert CD on CDROM/DVDROM.

3. Make sure to boot from CD/DVDROM

Choose “install ubuntu server”


4. Choose Language

Language chosen in this step will be work in the future use.

read more »

Howto reset mysql password on ubuntu server 9.10

New IBM server has arrived, its IBM X3100-42X.

Standard install required; DNS, LAMP and OpenSSH server on  Ubuntu Server 9.10.

Problem came when I forgot password for MySQL. I think the solution isn’t far from what I done in FreeBSD.

First attempt login to MySQL server :

# mysql -uroot -p

Enter password:
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)

Look MySQL process :

read more »