SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: Two passwords

  1. #1
    Get my greedy down dotJoon's Avatar
    Join Date
    Apr 2003
    Location
    daejeon, South Korea
    Posts
    2,223
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Two passwords

    I have two databases in mySQL.

    The first database is named "onlyMe".
    The second database is named "together".

    I can access to the databases with ID "root" and password "1111".
    at the moment.

    Can I make the password of "onlyMe" is "1111", and the password of "together" is "2222".



    I like to access to "onlyMe" exclusively, and I like to access to "together" with one of my cooporative potential partners.

    Can I make it possible?

  2. #2
    SitePoint Enthusiast ArgentinaCoders's Avatar
    Join Date
    Nov 2003
    Location
    Argentina
    Posts
    56
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I don't understand what is your problem, try to be more specific.

  3. #3
    Chessplayer kleineme's Avatar
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    608
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    you will not be able to use two passwords for the same ID. You may create a new ID and then give the appropriate rights to this new account. The following chapter of the manual may suit your needs:


    http://dev.mysql.com/doc/mysql/en/Adding_users.html
    Never ascribe to malice,
    that which can be explained by incompetence.
    Your code should not look unmaintainable, just be that way.

  4. #4
    Get my greedy down dotJoon's Avatar
    Join Date
    Apr 2003
    Location
    daejeon, South Korea
    Posts
    2,223
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    I meant two IDs.

    I admit I wrote poorly about my problem.

    It's not because I wrote it careless. but it it's because I didn't know what's the key point in my problem.

    I've solved my problem now.

    anyway thank you
    Last edited by dotJoon; May 7, 2004 at 13:49.


Bookmarks

Posting Permissions

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