Mysql Socket Error

Hi,

Getting the following Socket error.

Error:
can't connect to local MySql server through socket
'var/lib/mysql/mysql.sock' (2)

In case loading via the safe mode, mysql works i.e.
executing the following statement.
/usr/local/mysql]# bin/mysqld_safe --socket =
/tmp/mysql.sock

But on restarting the machine get the following error:


Error 2002: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (2)

Could someone please help and tell me how to resolve
this one.

Thanks
Kanan


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
kanan thakore [ Fr, 03 Oktober 2003 16:17 ] [ ID #67395 ]

Re: Mysql Socket Error

On Fri, Oct 03, 2003 at 07:17:18AM -0700, kanan thakore wrote:
> Hi,

Hi !!
>
> Getting the following Socket error.
>
> Error:
> can't connect to local MySql server through socket
> 'var/lib/mysql/mysql.sock' (2)
>
> In case loading via the safe mode, mysql works i.e.
> executing the following statement.
> /usr/local/mysql]# bin/mysqld_safe --socket =
> /tmp/mysql.sock

Means that the default my.cnf file is picking the
/var/lib/mysql/mysql.sock. Please cross check that and fix it..

>
> But on restarting the machine get the following error:
>
>
> Error 2002: Can't connect to local MySQL server
> through socket '/tmp/mysql.sock' (2)
>
> Could someone please help and tell me how to resolve
> this one.
>
> Thanks
> Kanan
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product search
> http://shopping.yahoo.com
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=venu [at] mysql.com

--

Venu, Software Developer
Palo Alto, CA, USA
MySQL Inc, http://www.mysql.com


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
Venu [ Fr, 03 Oktober 2003 21:27 ] [ ID #67396 ]
Datenbanken » gmane.comp.db.mysql.odbc » Mysql Socket Error

Vorheriges Thema: Re: Bug #1388 [Opn->!Bg]: MyODBC ignores decimals of a float for client using comma as decimal se
Nächstes Thema: bk commit - MyODBC 3.51 (1.308)