2009/08/31

MacBook Pro - share internet connection with Windows PDA via Bluetooth

To share 3G connection from PDA to MacBook, here's the steps:

1. Turn on Bluetooth on both devices (MBP and PDA)
2. Pair up (if you're not yet done it)
3. Start the internet sharing program on PDA
4. On MBP, click on the bluetooth icon on the menu bar (assuming you have it on the menu bar), under your PDA device, select "Connect".
5. Happy browsing.

My working device is: MBP 990 (OSX 10.5.8), HTC Curise (WM 6.1).

2009/08/30

Quickest way to reset mysql root password

If you forgot root password for MySQL, this is the quickest way to reset it. You need to have root access to the box.
service mysqld stop

wait until MySQL shuts down. Then run
mysqld_safe --skip-grant-tables &

**In Windows, cd to mysql path, e.g. C:\Program Files\MySQL\MySQL Server 5.1\bin, then
mysqld.exe -u root --skip-grant-tables


then you will be able to login as root with no password.
mysql -u root

In MySQL command line prompt issue the following command:
mysql> use mysql;
mysql> UPDATE user SET password=PASSWORD('the_new_password') WHERE user='root';
mysql> FLUSH PRIVILEGES;

At this time your root password is reset and MySQL will now know the privileges and you'll be able to login with your new password:
mysql -u root -p


Back to production mode
killall mysqld
service mysqld start

Mercury簡易改裝

有同好有一樣的困擾 - 如何使用自己的data logging軟體,因此寫了這篇來分享我的簡易改裝。 Background 雲豆子 MERCURY roaster 烘豆機的設計是使用自行開發的軟體,來:1. 操控風門/火力; 2. data logging/自動烘焙。 ...