How do I make my MySQL server use TCP connections instead of Unix sockets?

Want to support HowtoForge? Become a subscriber!
 
Submitted by till (Contact Author) (Forums) on Mon, 2006-08-07 16:25. :: MySQL | ISPConfig

Comment out the option skip-networking in the file my.cnf which typically lies under /etc or /etc/mysql. Then restart your MySQL server:

/etc/rc.d/init.d/mysql restart

or

/etc/init.d/mysql restart

With

netstat -ta

you can check if MySQL is reachable via TCP.


Please do not use the comment function to ask for help! If you need help, please use our forum.
Comments will be published after administrator approval.