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;