How to enable remote access to your mysql database (debian)
Submitted by admin on Sat, 2007-04-07 02:18.
Communications | Database Software
1) nano /etc/mysql/my.cnf
2) find
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/English
bind-address = 65.55.55.2
3) the bind address will initially say localhost... change it to be your ipaddress of the server.
4) /etc/init.d/mysql restart
5) modify the permissions in mysql to allow remote users to log in.
thats it your done.

Recent comments
39 weeks 3 days ago
49 weeks 4 days ago
49 weeks 4 days ago
1 year 2 weeks ago
1 year 9 weeks ago
1 year 11 weeks ago
1 year 23 weeks ago
1 year 23 weeks ago
1 year 24 weeks ago
1 year 38 weeks ago