Setting up a database and creating a user to have access to it is quite a simple job.

(more…)

I managed to get the 8i DBA course completed from Learning Tree and have not yet upgraded. I work mostly with 10g and 9i now, so I suppose I should really get to it.

Changing a users password without a GUI in Oracle is pretty straight forward.

ALTER USER <username> IDENTIFIED BY <new password>;

Note the lack of quotes.

For MySQL its similar

update user set password=PASSWORD("<new password>") where User='<username>';

You will need to flush the privileges to make this effective.

flush privileges;