how did u connect mysql on your laptop
On Thu, Oct 18, 2012 at 1:19 AM, kalin <kalin@stripped> 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 <anandkl@stripped
>> <mailto:anandkl@stripped>> wrote:
>>
>> does both directory have permission "777"
>>
>>
>> On Wed, Oct 17, 2012 at 9:27 PM, Rick James <rjames@stripped
>> <mailto:rjames@stripped>> wrote:
>>
>> SELinux ?
>>
>> > -----Original Message-----
>> > From: Lixun Peng [mailto:penglixun@stripped
>> <mailto:penglixun@stripped>]
>> > Sent: Tuesday, October 16, 2012 9:03 PM
>> > To: kalin
>> > Cc: Michael Dykman; mysql@stripped
>> <mailto:mysql@stripped>
>> > 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 <kalin@stripped
>> <mailto:kalin@stripped>> 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"
> <penglixun@stripped
>> <mailto:penglixun@stripped>> 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 <kalin@stripped
>> <mailto:kalin@stripped>> 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>
>>
>> > >> 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>
>>
>> > Twitter: http://www.twitter.com/plinux
>> > Blog: http://www.penglixun.com
>>
>>
>>
>>
