Open network access for mysql on ubuntu server

alamster — Mon, 12 Oct 2009 02:10:41 +0000

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

$ mysql -ubox-p -h box.rasyid.net

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

Edit my.cf file :

# nano /etc/mysql/my.cnf

find this line :

bind-address = 127.0.0.1

add # in the front into

#bind-address = 127.0.0.1

save and restart mysql.

Re try again :

$ mysql -ubox -p -h box.rasyid.net

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.

mysql>

Copyright © 2009 Learning On Demand. This Feed is for personal non-commercial use only. If you are not reading this material in your news aggregator, the site you are looking at is guilty of copyright infringement. Please contact alamster@gmail.com so we can take legal action immediately.
Plugin by Taragana

Create tar.gz in OpenSolaris

alamster — Sun, 11 Oct 2009 07:01:45 +0000

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 -