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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s