Users in phpMyadmin

Discussion in 'MySQL' started by Kuna, Nov 6, 2012.

0
  1. #1
    Could someone please explain me why do I need to set up users and add it to database? WHat do I get with that action?
     
    Solved! View solution.
    Kuna, Nov 6, 2012 IP
  2. GMF

    GMF Well-Known Member

    Messages:
    855
    Likes Received:
    113
    Best Answers:
    19
    Trophy Points:
    145
    #2
    Without knowing the context - now answer

    You get another user that is able (depending on rights) to connect to the database, create new database/tables, delete, modify, read etc..
     
    GMF, Nov 6, 2012 IP
  3. #3
    No one can connect to the database unless it's a user known to the database. The default user is root with no password. If you don't care about security, that's all you need. If the database is used on a public-facing site (IOW, you're not the only one connecting to it) you need secure (name/password pairs) users and you have to delete root as a user.
     
    Rukbat, Nov 6, 2012 IP
  4. Kuna

    Kuna Well-Known Member

    Messages:
    426
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    105
    #4
    thank you very much
     
    Kuna, Nov 7, 2012 IP