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
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.
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
- Asus EeeBox EBXB202-BLK-X0081
- Acer AspireRevo AR1600-U910H
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 🙂
pfSense is great stuff when you’re looking for Firewall but I need more 🙂
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.
I use 2 HDD ( system located in 8G HDD and second HDD for FTP data)
Ethernet 1 set for LAN ( ip address 192.168.12.110) 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.
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.
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
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)
Look MySQL process :