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
(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


