It shoul d be running as user mysql .
Mertens Bram wrote: >On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote: > >>As it says in the documentation, "If the LOCAL keyword is specified, >>the file is read from the client host. If LOCAL is not specified, the >>file must be located on the server." That means that with LOCAL the >>MySQL *client* must be able to access the file, but without LOCAL >>it's the MySQL *server* that needs access. The MySQL server probably >>doesn't (or at least shouldn't) have access to your home directory. >> > >Thx, I read that part but it didn't make much sense to me, but I think >I'm starting to see the light... > >As I read somewhere else in the documentation the mysql-daemon is run as >user nobody who has very little rights. So this user would indeed have >no rights for the specified file. I thought the root user was running >the mysql-daemon and that therefor both the server and client (which are >both running on my desktop computer) would have access to the file. >However according to ps -aux (I'm running mysql on a RH Linux box) the >only processes I see are owned by a user called mysql. > >Perhaps RH changed the username, they change quite a bit in certain >packages so this wouldn't surprise me. > >Anyway, it's working now, it's even making sense to me, so thanks a lot! > >Regards > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php