List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:February 18 2002 3:29pm
Subject:Re: mysql.sock problem
View as plain text  
check for a .my.cnf file in the user's home directory.  It may have 
conflicting entries.

Brad Emerson wrote:

>
> When I am logged in to my Linux system as root mysqladmin works 
> correctly.  i.e. finds mysql.sock in the correct location.
>
> When I am logged in as a normal user I get this error:
>
> Can't connect to local MySQL server through socket 
> /var/lib/mysql/mysql.sock.  blah blah...  (This is *not* the correct 
> mysql.sock)
>
>
> The issue is that my.cnf indicates /var/tmp/mysql.sock for both client 
> and mysqld.  And... it works fine when I am logged in as root.  As a 
> user it's trying to use the wrong mysql.sock file.  Any idea how to 
> fix this?  How I achieved the screwed up state?
>
> BTW, if I use --socket=/var/tmp/mysql.sock it works.  I hesitate to 
> consider it a longtem solution.
>
> Brad Emerson
>
>
>
>
> ---------------------------------------------------------------------
> 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 <mysql-thread100233@stripped>
> To unsubscribe, e-mail 
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


Thread
mysql.sock problemBrad Emerson17 Feb
  • Re: mysql.sock problemGerald Clark18 Feb
  • Re: mysql.sock problemBrad Emerson18 Feb