www.webdeveloper.com
Results 1 to 3 of 3

Thread: MYSQL5 and PHP5 Permissions

  1. #1
    Join Date
    Mar 2008
    Posts
    8

    MYSQL5 and PHP5 Permissions

    I new on a Ubutu LAMP server after ditching my Windoze IIS6 box. My question is "what permissions should the user be given for a db that is displayed on the web". Thanks

  2. #2
    Join Date
    Jun 2007
    Posts
    41
    Quote Originally Posted by adman4054 View Post
    I new on a Ubutu LAMP server after ditching my Windoze IIS6 box. My question is "what permissions should the user be given for a db that is displayed on the web". Thanks
    That's a vaguely worded question. There are permissions for multiple things on your new server, all of which need to be configured. Ordinarily, file permissions for anything readable from the web are set as read only, or for scripts which must execute, as read and execute only--but never as writeable. The files would be set this way as follows:

    Code:
    chmod 644 example_file.html  [read only]
    chmod 755 example_file.cgi  [read/execute only]
    However, permissions in the database are a separate issue. Depending on how you have set things up, it is likely that the CMS or application accessing the database will already have set permissions to acceptable values for you, and the public will not have direct access to the database, but only to the CMS which relays the information from the database.

    Blessings,

    PolyGreat

  3. #3
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    i'm not sure what a "user" is in this case. in general, apache servers are run as "nobody" and mysql as "mysql" they typically communicate using network traffic, no crossing of the users necessary in this case.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles