List:General Discussion« Previous MessageNext Message »
From:Joerg Bruehe Date:January 19 2011 3:42pm
Subject:Re: Can't read dir of '.' (errno: 13)
View as plain text  
Hi!


Jerry Schwartz wrote:
>> -[[...]]
>>
> [JS] I have a related question: how can MySQL authenticate a user if file 
> system permissions won't let it read any databases?

To me, your question sounds like you forgot the difference between
server and client:

- The MySQL server processes always run as the same operating system
  user (typically: "mysql"), and basic setup must ensure they have
  access rights to all files storing the database contents.

- The client processes run on any machine (local or remote) as any user,
  and that OS user may be totally unrelated to the database user that
  will be authenticated.

Just assume some application (with privilege checks!) accessed via the
web: The web server (Apache, ...) executing the PHP (or other) code is
running with some OS user ID which is the same for all application
(database) users, and there is no need to define those application users
on the machine running the server processes of Apache or MySQL.


HTH,
Jörg

-- 
Joerg Bruehe,  MySQL Build Team,  joerg.bruehe@stripped
ORACLE Deutschland B.V. & Co. KG,   Komturstrasse 18a,   D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603

Thread
Can't read dir of '.' (errno: 13)Adarsh Sharma19 Jan
  • Re: Can't read dir of '.' (errno: 13)Adarsh Sharma19 Jan
  • Re: Can't read dir of '.' (errno: 13)Pintér Tibor19 Jan
    • Re: Can't read dir of '.' (errno: 13)Yogesh Kore19 Jan
  • RE: Can't read dir of '.' (errno: 13)Jerry Schwartz19 Jan
    • Re: Can't read dir of '.' (errno: 13)Joerg Bruehe19 Jan
      • RE: Can't read dir of '.' (errno: 13)Jerry Schwartz19 Jan
        • Re: Can't read dir of '.' (errno: 13)Joerg Bruehe19 Jan
          • RE: Can't read dir of '.' (errno: 13)Jerry Schwartz19 Jan
            • Re: Can't read dir of '.' (errno: 13)Joerg Bruehe20 Jan
              • RE: Can't read dir of '.' (errno: 13)Jerry Schwartz20 Jan
          • Re: Can't read dir of '.' (errno: 13)Reindl Harald19 Jan