Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 3rd November 2012, 11:27
simonb simonb is offline
Junior Member
Join Date: Aug 2011
Posts: 13
Thanks: 1
Thanked 3 Times in 2 Posts
Default Adding remote access to a MySQL database does nothing

(ISPConfig Version: on Ubuntu 10.04)

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

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

I set the bind address in /etc/mysql/my.cnf
bind-address            =
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.
mysql -h c3songs -u c3songs -p 
Enter password: 
ERROR 1130 (HY000): Host '' 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 address.

mysql> select Host,User from mysql.user;
| Host               | User             |
|          | 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...

03.11.2012-09:35 - DEBUG - Found 1 changes, starting update process.
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...
GRANT ALL PRIVILEGES ON c3songs.* To 'c3songs'@'' IDENTIFIED BY '*****';

Last edited by simonb; 3rd November 2012 at 11:54.
Reply With Quote
Sponsored Links


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISPConfig 3 system installation script Mark_NL Tips/Tricks/Mods 14 18th November 2014 07:34
Can't login (w/ remote MySQL) menganito Installation/Configuration 3 16th May 2011 16:43
Strato Server - Restoring with SystemImager popper2001 HOWTO-Related Questions 5 28th July 2007 11:18
Support Ticket and MySQL Remote Access Question lewis_saint Installation/Configuration 3 21st May 2007 00:56
Creating image with Systemimager cuongtim HOWTO-Related Questions 3 18th November 2006 14:55

All times are GMT +2. The time now is 04:25.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.