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.bru...@oracle.com 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
