not sure i follow. what do you mean connect?!
there is a server (mysqld) and a client (mysql). the client gets to the server via the socket. like on any other unix machine.
how did i connect mysql to what exactly? On 10/18/12 6:42 AM, Ananda Kumar wrote:
how did u connect mysql on your laptop On Thu, Oct 18, 2012 at 1:19 AM, kalin <ka...@el.net <mailto:ka...@el.net>> wrote: thanks amanda... the "local" worked for some reason... in about 10 years of using mysql i have never had to do that. i still wonder why would the thing not stat it. file and dir are both 777 and owned by mysql... one thing i noticed thou is that the actual user is not mysql but _mysql. that's how is stored in passwd and that's how it's represented by ls -al. the process thou was started with --user=mysql... but i still don't get the necessity of "local". i have never used it before. this is all on os x - 10.8.2... On 10/17/12 1:25 PM, Ananda Kumar wrote: also try using "load data local infile 'file path' and see if it works On Wed, Oct 17, 2012 at 10:52 PM, Ananda Kumar <anan...@gmail.com <mailto:anan...@gmail.com> <mailto:anan...@gmail.com <mailto:anan...@gmail.com>>> wrote: does both directory have permission "777" On Wed, Oct 17, 2012 at 9:27 PM, Rick James <rja...@yahoo-inc.com <mailto:rja...@yahoo-inc.com> <mailto:rja...@yahoo-inc.com <mailto:rja...@yahoo-inc.com>>> wrote: SELinux ? > -----Original Message----- > From: Lixun Peng [mailto:pengli...@gmail.com <mailto:pengli...@gmail.com> <mailto:pengli...@gmail.com <mailto:pengli...@gmail.com>>] > Sent: Tuesday, October 16, 2012 9:03 PM > To: kalin > Cc: Michael Dykman; mysql@lists.mysql.com <mailto:mysql@lists.mysql.com> <mailto:mysql@lists.mysql.com <mailto:mysql@lists.mysql.com>> > Subject: Re: error 13 > > Hi, > > you can switch to mysql user "su - mysql", and then stat this file. > if you can't access, mysql user have not permissions. > > On Wed, Oct 17, 2012 at 11:49 AM, kalin <ka...@el.net <mailto:ka...@el.net> <mailto:ka...@el.net <mailto:ka...@el.net>>> wrote: > > > > > > > > > On 10/16/12 10:49 PM, Michael Dykman wrote: > > > >> is your mysql client on the same host as the mysql server? if not, > >> google the docs for 'local infile' > >> > > > > yes. my laptop. > > > > > > > > > > > >> On 2012-10-16 10:45 PM, "Lixun Peng" <pengli...@gmail.com <mailto:pengli...@gmail.com> <mailto:pengli...@gmail.com <mailto:pengli...@gmail.com>>> wrote: > >> > >> Hi, > >> > >> What's the dir permissions? > >> > >> For example, if we have a file in /a/b/file, dir a is 644, even > >> though file is 777, we can't access file, too. > >> > >> > >> On Wed, Oct 17, 2012 at 10:31 AM, kalin <ka...@el.net <mailto:ka...@el.net> <mailto:ka...@el.net <mailto:ka...@el.net>>> wrote: > >> > >> > >>> > >>> hi all.. > >>> > >>> this hasn't happe... > >>> > >> -- > >> Senior MySQL Developer @ Taobao.com > >> > >> Mobile Phone: +86 18658156856 (Hangzhou) > >> Gtalk: penglixun(at)gmail.com <http://gmail.com> <http://gmail.com> > >> Twitter: http://www.twitter.com/plinux > >> Blog: http://www.penglixun.com > >> > >> > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql > > > > > > > -- > Senior MySQL Developer @ Taobao.com > > Mobile Phone: +86 18658156856 (Hangzhou) > Gtalk: penglixun(at)gmail.com <http://gmail.com> <http://gmail.com> > Twitter: http://www.twitter.com/plinux > Blog: http://www.penglixun.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
