|  About Me  |  Blogs  |  Photos  |  Publications  |  Resume  | 

Archive for August, 2004

Reset MySQL password

Thursday, August 26th, 2004

Here’s how to reset the forgotten root password for mysql,

$ sudo su
$ /etc/init.d/mysql stop
$ mysqld –skip-grant-tables
$ mysql -u root mysql
mysql>UPDATE user SET Password=PASSWORD(’newpwd’) WHERE User=’root’;
mysql> FLUSH PRIVILEGES;
mysql>quit
$ /etc/init.d/mysql start

Installing Movabletype 3.1rc1 beta

Thursday, August 26th, 2004

Installation notes for movabletype 1.3rc1 using mysql.

Create new database and user priviledges for mt beta

$ mysqladmin create mtbeta
$ mysql -uroot mysql
$ grant all privileges on mtbeta.* to ‘movabletype’@'localhost’ identified by ‘password’ with grant option;
$ mysqladmin reload

Configure movabletype


CGIPath http://ibao.hopto.org/mt-beta/

#DataSource ./db

ObjectDriver DBI::mysql
Database mt-beta
DBUser movabletype
DBHost localhost
DBSocket /var/run/mysqld/mysqld.sock

Place password in /var/www/mt-beta/mt-db-pass.cgi,

Set apache permission.

<Directory “/var/www/mt-beta”>
Options Indexes [...]

Network interface script to enable dhcp interface for dnsmasq

Wednesday, August 25th, 2004

My wireless interface have many profiles, some profiles run as dhcp client while others run as dhcp server. This means I have to setup my dhcp server (I use dnsmasq) to listen on the interface when the profile that acts as dhcp server is brought up, and remove that interface when the profile is brought [...]

How to play DVD (vob) files on disk using MPlayer

Tuesday, August 24th, 2004

$ mplayer dvd://1 -dvd-device /path/to/dvd_files

Compiling kernel 2.6.8 for IBM Thinkpad T41

Monday, August 23rd, 2004

Notes on compiling linux kernel 2.6.7 / 2.6.8 to support mts, wifi and bluetooth on a T41 running debian.

Using CUPS printers with lpr

Monday, August 23rd, 2004

CUPS is a general replacement for lpd and the likes. If we want lpr to use CUPS printers we also need to install cupsys-bsd package.