Database users

How do i give a database user a password

Which database application is it (MySQL, Postresql, Oracle, etc)

Its MySQL 4

MySQL has a wonderful online manual that I'd highly recommend to bookmark if you are playing in MySQL. The section on setting up and changing passwords: http://www.mysql.com/doc/en/Passwords.html

:D

Hope that helps.

You would do it using the GRANT option.


Looks something like...


grant select, delete, update
on database.*
for user with password'password';

Its 4am and that syntax may be off just a bit, but you should get the general idea.

GRANT is what your looking for.