PHP/Mysql

Discussion in 'PHP' started by mringuk, Nov 3, 2008.

  1. #1
    Is it possible with a UserName / Password database to set a Master UserName / Password to access all records for admin purposes.
     
    mringuk, Nov 3, 2008 IP
  2. bartolay13

    bartolay13 Active Member

    Messages:
    735
    Likes Received:
    14
    Best Answers:
    1
    Trophy Points:
    98
    #2
    not sure of this.. are you refering about remote access the database in the server?
     
    bartolay13, Nov 3, 2008 IP
  3. dev_SeeInside

    dev_SeeInside Peon

    Messages:
    45
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    When I need to do this, I usually would use a field in the users table that stores a user access level that I can check or a combination of bits to determine what a user can and can't access. Or, You could create an admin tool that lists user accounts, so when an administrator clicks on a user name, they are automatically logged in as that user for administrative purposes.

    Sorry to be so vague, but your question could have a lot of different answers :)
     
    dev_SeeInside, Nov 3, 2008 IP
  4. maestria

    maestria Well-Known Member

    Messages:
    705
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #4
    For a particular database, you can set an admin username and password kind of thing using grant all privilege sql statement.
     
    maestria, Nov 4, 2008 IP
  5. garrettheel

    garrettheel Peon

    Messages:
    341
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #5
    You would need to make a special login script where the user enters the user they want to be logged in as and an admin username and password
     
    garrettheel, Nov 4, 2008 IP