i mean ...do u connect just like mysql -u <username> -p
or mysql -u <username> -p <password> -h hostname On Thu, Oct 18, 2012 at 11:07 PM, kalin <ka...@el.net> wrote: > > 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 >> >> >> >> >>