Database users
Results 1 to 5 of 5

Thread: Database users

  1. #1

    Database users

    How do i give a database user a password

  2. #2
    Just a Virtualized Geek MrLinus's Avatar
    Join Date
    Sep 2001
    Location
    Redondo Beach, CA
    Posts
    7,324
    Which database application is it (MySQL, Postresql, Oracle, etc)
    Goodbye, Mittens (1992-2008). My pillow will be cold without your purring beside my head
    Extra! Extra! Get your FREE copy of Insight Newsletter||MsMittens' HomePage

  3. #3
    Its MySQL 4

  4. #4
    Just a Virtualized Geek MrLinus's Avatar
    Join Date
    Sep 2001
    Location
    Redondo Beach, CA
    Posts
    7,324
    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



    Hope that helps.
    Goodbye, Mittens (1992-2008). My pillow will be cold without your purring beside my head
    Extra! Extra! Get your FREE copy of Insight Newsletter||MsMittens' HomePage

  5. #5
    Webius Designerous Indiginous
    Join Date
    Mar 2002
    Location
    South Florida
    Posts
    1,123
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •