From: kalin
Date: October 18 2012 5:37pm
Subject: Re: error 13
List-Archive: http://lists.mysql.com/mysql/228456
Message-Id: <50803E50.2070109@el.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


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 <kalin@stripped
> <mailto: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>
>         <mailto: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>
>              <mailto:rjames@stripped
>         <mailto:rjames@stripped>>> wrote:
>
>                  SELinux ?
>
>                   > -----Original Message-----
>                   > From: Lixun Peng [mailto:penglixun@stripped
>         <mailto:penglixun@stripped>
>                  <mailto:penglixun@stripped <mailto:penglixun@stripped>>]
>                   > Sent: Tuesday, October 16, 2012 9:03 PM
>                   > To: kalin
>                   > Cc: Michael Dykman; mysql@stripped
>         <mailto:mysql@stripped>
>                  <mailto: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>
>                  <mailto: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>
>                  <mailto: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>
>                  <mailto: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>
>         <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
>
>
>
>