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

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.

Till Brehm

About Till Brehm

Over 20 years experience as Software Developer and Linux System Administrator. Till Brehm is the founder and lead developer of the ISPConfig Hosting Control Panel software (since 2000) and he founded HowtoForge in 2005 as a place to share Linux knowledge with other Linux enthusiasts.

Share this page:

Suggested articles

0 Comment(s)

Add comment