Archive for December 29, 2009

Run mysql on localhost

Posted: December 29, 2009 in archlinux, Debian, Freebsd, Slackware

Run mysql on localhost only.

on freebsd go to

[root@bsd /home/mynux]# cd /usr/local/share/mysql/

[root@bsd /usr/local/share/mysql]# cp my-large.cnf my.cnf

[root@bsd /usr/local/share/mysql]# mv my.cnf /usr/local/etc/

[root@bsd /usr/local/share/mysql]# pico my.cnf

than put this on my.cnf after [mysqld]

bind-address=127.0.0.1

than restart mysql server

[root@bsd /usr/local/etc]# /etc/rc.d/mysql-server restart

than nmap from other server to see yor mysql is hidden from outside ;p.