How to change MySQL user password

at the "mysql>" prompt, type:
set password = password("yournewpassword");

*I always forget this, I need to jot down*

Start postgresql, create database and access it

Platform:FreeBSD

# su - pgsql
$ initdb -D /usr/local/pgsql/data (if only doesn't exist)
$ postgres -D /usr/local/pgsql/data >logfile 2>&1 &
$ createdb test
$ psql test

Install: using ports
Binary location: /usr/local/bin
Don't forget to modify rc.conf

Set mysql root password

To set password for the first time:
$ mysqladmin -u root password NEWPASSWORD

To change password:
$ mysqladmin -u root -p OLDPASSWORD NEWPASSWORD

To login with password:
$ mysql -u root -p PASSWORD

To change password mysql sql command:
mysql> use mysql;
mysql> update user set password=OLDPASSWORD("NEWPASSWORD") where User='USERNAME';
mysql> flush privileges;
mysql> quit

Check Oracle version

1) run sqlplus
2) su - oracle and run svrmgrl