Open network access for mysql on ubuntu server

Error message came out when I try to access new vps server :

$ mysql -ubox-p -h

Enter password:
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘’ (61)

Edit file :

# nano /etc/mysql/my.cnf

find this line :

bind-address           =

add # in the front into

#bind-address           =

save and restart mysql.

Re try again :

$ mysql -ubox -p -h

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 50
Server version: 5.0.75-0ubuntu10.2 (Ubuntu)

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


Create tar.gz in OpenSolaris

I need to make backup for our public_html directory

using tar command I used to use :

tar cvzf  filename.tar.gz directory_name

It work in linux or bsd but I have different situation with OpenSolaris :

# uname -a

SunOS TGLxxxxxxx 5.11 snv_86 i86pc i386 i86xpv

# tar cvzf public_html.tar.gz public_html

tar: z: unknown function modifier
Usage: tar {c|r|t|u|x}[BDeEFhilmnopPqTvw@/[0-7]][bfk][X…] [blocksize] [tarfile] [size] [exclude-file…] {file | -I include-file | -C directory file}…

Combine it with gzip using pipe will give tar.gz file :

tar cvf -  public_html | gzip > public_html.tar.gz

Yes, it works!

scp time.

P.S :

In case you want to extract .tar.gz file in OpenSolaris use this command :

gzip -dc filename.tar.gz | tar xvf –

How to change proxy information on ubuntu server

New motherboard has come and I ask my friend to install Ubuntu Hardy . Everything is fine except proxy section when I try to apt-get update.

# apt-get update

Err hardy-security Release.gpg
Could not resolve ‘;3128’
Err hardy-security/main Translation-en_US
Could not resolve ‘;3128’
Err hardy-security/restricted Translation-en_US
Could not resolve ‘;3128’
Err hardy-security/universe Translation-en_US
Could not resolve ‘;3128’

As you see proxy information is incorrect, there is a ; sign not :

read more »

How to change timezone on ubuntu

One of my friend server must get reconfigure its clock each time, specially when the server get reboot after lamp problem.

Until he realized the timezone is different.

Here’s quick way to change it :

# dpkg-reconfigure tzdata

Current default timezone: ‘Asia/Jakarta’
Local time is now:      Sat Oct  3 13:02:53 WIT 2009.
Universal Time is now:  Sat Oct  3 06:02:53 UTC 2009.


# date

Sat Oct  3 13:03:15 WIT 2009

Great, it fix.