SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    if ($zee == "Guru") { $zee--;}
    Join Date
    Nov 2005
    Location
    Karachi - Pakistan
    Posts
    1,134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    username and password (was "MySQL Questions (Will Help Readers. Once answered)")

    Hi Gurus,

    I m making a dynamic website.
    I m now installing MySQL on my computer. I know that for the security reasons I should not use the Default ROOT username and its passwrd.

    Now I want to know that what should I Do ? Like, okay I will change that ROT username and Passwrd. But for the visitors to use my web, Should i create some other account for the visitors ? only having Reading and Writing rights no deleting rights ?????

    Moreover, like if there is a need that the Visitor will delete his entries ? then what account should I use?

    2ndly, what to do for the ADMIN account ?

    Please help

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    i typically set up 2 mysql user accounts for my website: one for logged in users, and one for visitors. visitors only have INSERT and UPDATE rights on specific tables where necessary. once a user logs in, my PHP scripts detect a logged in user using session variables and uses a different user account for all the mysql queries. this second account has more rights, but never more than is strictly needed to do what they need to do.


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
  •