Allowing Remote Hosts on Mysql With FreeBSD

vi /var/db/mysql/my.cnf
(if it’s not there copy a config from /usr/local/share/mysql/ to /var/db/mysql)

Add the following line (YOUR server ip):
bind-address = 123.123.123.123

stop mysql:
ps -aux |grep mysql
kill -TERM 12345

start mysql:
/usr/local/libexec/mysqld –user=mysql &

add access to database:
mysql> GRANT ALL ON databasename.* TO username@’123.123.123.124′ IDENTIFIED BY ‘GOODPASSWORD’;

Using the mysql client from remote the ip of 123.123.123.124:
mysql -u webadmin –h 123.123.123.123 –p

That should do it

-AK