View the Most Wanted LQ Wiki articles.
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 01-19-2004, 03:54 AM   #1
Registered: Jan 2004
Posts: 54

Rep: Reputation: 15
How to set SQL to UNIX socket

I have recently installed MySQL on my nix box and wanted SQL to run on a UNIX socket.

so i did ./configure --prefix= ..........--with-unix-socket-path=/var/lib/mysql/mysql.sock .....
then a make and make install

but now when i start mysqld and do a netstat -vat ...i find that MySql is using protocol TCP ...shouldnt it be UNIX???

<newbie alert!!! > so forgive me if i sound confused
Old 01-19-2004, 07:20 AM   #2
Senior Member
Registered: Apr 2003
Location: Eire
Distribution: Slackware 12.0, OpenSuse 10.3
Posts: 1,120

Rep: Reputation: 45
In general if the client program that is trying to connect to mysql on the same machine they can use UNIX sockets , then as far as I am aware they will use them - to turn off listening on tcp sockets completely uncomment skip-networking in your my.cnf file and it will only listen on unix sockets - the netstat output will disappear.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
unix domain socket: how to know if i use recvmsg or read Thinking Programming 3 09-23-2005 02:51 AM
Unable to connect to UNIX socket /tmp/.esd/socket error while using grip dr_zayus69 Linux - Software 4 08-23-2005 08:28 PM
(C++) Unix/Linux Networking Socket tutorials ? Dark Carnival Programming 7 08-09-2004 06:43 PM
Unix socket programming - how to sent a file Scrag Programming 9 03-28-2004 10:54 PM
KDevelop Unix Socket Problem shibdas Linux - Software 0 07-30-2003 02:50 PM

All times are GMT -5. The time now is 09:44 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration