HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials - Adding remote access to a MySQL database does nothing

(ISPConfig Version: 3.0.4.6 on Ubuntu 10.04)

I need to make a MySQL database accessible to a remote server on the LAN. ISPConfig is running on 192.168.108.129.

I check the "Remote Access" checkbox and enter the IP of the remote server, 192.168.108.140, in the "Remote Access IP" textbox.

I set the bind address in /etc/mysql/my.cnf

Code:

bind-address = 0.0.0.0

I open port 3306 on the firewall for the remote server. Port 3306 appears open if I test it with nmap on the remote server. So far so good.

However I can't access the database from the remote server.

Code:

mysql -h 192.168.108.129 c3songs -u c3songs -p 

Enter password: 

ERROR 1130 (HY000): Host '192.168.108.140' is not allowed to connect to this MySQL server

If I log into mysql as root on the ISPConfig server then there doesn't appear to be a c3songs user created for the 192.168.108.140 address.

Code:

mysql> select Host,User from mysql.user;

+--------------------+------------------+

| Host               | User             |

+--------------------+------------------+

| 127.0.0.1          | root             |

| ispconfig.example.com | root             |

...(abbreviated, other users listed here)

| localhost          | c3songs          |

... (abbreviated, other users listed here)

| localhost          | ispconfig        |

| localhost          | root             |

+--------------------+------------------+

19 rows in set (0.00 sec)

Is ISPConfig doing anything to enable remote access? I can't see any evidence of it in the database unless I am missing something.

If I set the logging level to debug and run server.sh at the command line I see the following related output when I enable external dB access...

Code:

03.11.2012-09:35 - DEBUG - Found 1 changes, starting update process.

/usr/bin/fail2ban-client

/sbin/iptables

/sbin/ip6tables

03.11.2012-09:35 - DEBUG - Calling function 'db_update' from plugin 'mysql_clientdb_plugin' raised by event 'database_update'.

03.11.2012-09:35 - DEBUG - Changing MySQL remote access privileges for database: c3songs

03.11.2012-09:35 - DEBUG - Processed datalog_id 254

If I add permissions manually then I can access the database from the remote server. But shouldn't ISPConfig be doing that for me?

This works...

Code:

GRANT ALL PRIVILEGES ON c3songs.* To 'c3songs'@'192.168.108.140' IDENTIFIED BY '*****';