How do i give a database user a password
Printable View
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.