This is under: http://www.ki.nu/software/pkgsrc/

NetBSD/pkgsrc

reset password

stop and restart with "--skip-grant-tables"

/etc/rc.d/mysqld stop env mysqld_flags=--skip-grant-tables /etc/rc.d/mysqld start

start mysql session

# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.15-Debian_1-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql>

modify password

mysql> use mysql; mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root'; mysql> flush privileges; mysql> quit

restart mysql

# /etc/rc.d/mysqld stop # /etc/rc.d/mysqld start

Confirm above operation

# mysql -u root -p