LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 01-19-2004, 03:54 AM   #1
Skunk_Face
Member
 
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
Looking_Lost
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.
 
  


Reply


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 08:28 AM.

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