SitePoint Sponsor

User Tag List

Results 1 to 11 of 11

Hybrid View

  1. #1
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    password protection for mySQL ?

    Is it possible for me to password protect the entire mySQL database file, seeing as to how someone can just copy the db out and reopen it in another mySQL application?

    What other forms of password protection does mySQL offer? Table locking, diff. granularities etc.

  2. #2
    You talkin to me? Anarchos's Avatar
    Join Date
    Oct 2000
    Location
    Austin, TX
    Posts
    1,438
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The database files are already protected: they're chmodded 700.
    ck :: bringing chris to the masses.

  3. #3
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    they are??

    does this mean that if i port my files to another mySQL app in another PC, they wouldn't open?

  4. #4
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    anybody want to contribute their 3 cents worth?

  5. #5
    SitePoint Enthusiast
    Join Date
    Aug 2001
    Location
    NJ
    Posts
    68
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i have mysql on a windows machine, just for testing, but how does the protection work here? (no chmod)
    signature

  6. #6
    SitePoint Enthusiast cragthehack's Avatar
    Join Date
    Jul 2001
    Location
    Ft. Lauderdale, FL. USA
    Posts
    94
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Actually I'm not so sure you can just copy the mySQL data file and transport it. I always went through some sort of export routine (like a SQL statement). How would a user get access to the data directory anyway?
    - crag
    net geek for non profits and political campaings

  7. #7
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yea.. i'm dyin' to know too!

  8. #8
    You talkin to me? Anarchos's Avatar
    Join Date
    Oct 2000
    Location
    Austin, TX
    Posts
    1,438
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by infinitium
    yea.. i'm dyin' to know too!
    I think you need to read some basic linux books and/or man chmod
    ck :: bringing chris to the masses.

  9. #9
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What I think Anarchos is trying to say, keyword "think", The db files have 700 permissions, which means that they can't be accessed by anyone except root and the owner of the db files, at least on unix systems. So yes you are safe there, on windows, you should not be running live stuff from your test box, furthermore when using Winblows for serving websites, users should never be allowed access to any part of the file system except for the web folders from the outside.
    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  10. #10
    You talkin to me? Anarchos's Avatar
    Join Date
    Oct 2000
    Location
    Austin, TX
    Posts
    1,438
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Plus if you're using NTFS you can restrict access to the files through the filesystesm as well.
    ck :: bringing chris to the masses.

  11. #11
    SitePoint Addict
    Join Date
    Jun 2001
    Location
    Malaysia
    Posts
    352
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by freddydoesphp
    What I think Anarchos is trying to say, keyword "think", The db files have 700 permissions, which means that they can't be accessed by anyone except root and the owner of the db files, at least on unix systems. So yes you are safe there, on windows, you should not be running live stuff from your test box, furthermore when using Winblows for serving websites, users should never be allowed access to any part of the file system except for the web folders from the outside.
    Yeah, that's what I've been doing so far. Question: I'm on Win2k.. say i port mySQL database files along with all my PHP files to another Win2k machine, running on mySQL as well. Would mySQL be able to open and read the database?

    All this done assuming that I also change the mysql_connect root and password option to reflect the new PC's owner.


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
  •