Setting PATH for MYSQL bin

MYSQL PATH! 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 …

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.

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 …

More

Download FreeBSD 8 RC3 iso file

FreeBSD 8 RC3 already out, ready to test for all your machine. Choose your favourite forms : BootOnly CD (disc 1) DVD LifeFS MemStick Upgrade method : cvsup, use  “RELENG_8_0″ freebsd-update ( freebsd-update upgrade -r 8.0-RC3 ) More information for freebsd-update available here. More information about this RC please read release announcement.

Open network access for mysql on ubuntu server

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 …

More

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 …

More

How to change proxy information on ubuntu server

New motherboard has come and I ask my friend to install Ubuntu Hardy 8.0.4.3 . Everything is fine except proxy section when I try to apt-get update. # apt-get update Err http://security.ubuntu.com hardy-security Release.gpg Could not resolve ‘172.88.1.3;3128′ Err http://security.ubuntu.com hardy-security/main Translation-en_US Could not resolve ‘172.88.1.3;3128′ Err http://security.ubuntu.com hardy-security/restricted Translation-en_US Could not resolve ‘172.88.1.3;3128′ Err …

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 …

More

How to extend / renew flickr pro account

My wife flickr account pro almost expire, it will expire on October 2009. Since she stay at my mother in law house with our newly born child she ask me to renew her account on flickr. I thought the process is quite clear but I’ll post it for some people that might have difficult on …

More

Howto install Aptana studio with php support

I’m old fashion student who use phpcoder as tool for coding php until my friend suggest aptana editor with php support. When everything configured properly I’ll have php interpreter for immediate debug purpose and I think it’s suitable for new php user I decide to give this software a try and here it goes. Install …

More

WARNING: Found /var/db/mysql/my.cnf

MySQL 5.4 beta already hit freebsd ports and I eager to try it after read a lot of review. Everyhing seem OK until I want to start the server. # /usr/local/etc/rc.d/mysql-server restart mysql not running? (check /var/db/mysql/proxy2.host.com.pid) hmmm, perhaps I can try mysqld_safe # /usr/local/bin/mysqld_safe & [1] 87164 proxy2# WARNING: Found /var/db/mysql/my.cnf Datadir is deprecated …

More

How to Setting ntp client in Mikrotik

RouterBoard have special behavior, that’s my observation after install MT in hard disk and then bought RB433AH. In RB433AH time setting automatically to January 1970 every time its get restart. Till I use ntp (network time protocol) client in MT. The step to set ntp client in MT : 1. Click ‘System’ -> NTP Client. …

More