what is root

Discussion in 'MySQL' started by no-money, Jun 11, 2006.

  1. #1
    $connect = @mysql_connect('localhost', 'root', 'pass');


    Could someone explain to me what the root will be, is it the DB Name?

    Thanks
     
    no-money, Jun 11, 2006 IP
  2. themole

    themole Peon

    Messages:
    82
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #2
    'localhost' = servername
    'root' = username
    'pass' = password


    http://us2.php.net/manual/en/function.mysql-connect.php

    Don't forget you can use PHP.net to lookup functions and find out what they do and what their parameters are

    -the mole
     
    themole, Jun 11, 2006 IP
  3. iatbm

    iatbm Prominent Member

    Messages:
    5,151
    Likes Received:
    352
    Best Answers:
    0
    Trophy Points:
    360
    #3
    root is the username and it means administrator(superuser) in unix/linux systems...This is the user with all privilages to the system. To change, delete, add system files and all other users files.

    root for mysql .... read above

    You should use root username only when you are administrating your system or database (adding users, databases, changing files)

    for you to connect to database always use premade normal users which has privilage to change only database assigned to him

    with root user of course you have all privilages

    http://dev.mysql.com/doc/refman/5.0/en/
     
    iatbm, Jun 11, 2006 IP
  4. designcodes

    designcodes Well-Known Member

    Messages:
    213
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    133
    #4
    the name you used when you installed the database.
     
    designcodes, Jun 26, 2006 IP
  5. sadcox66

    sadcox66 Spirit Walker

    Messages:
    496
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #5
    sadcox66, Jun 27, 2006 IP