HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials - How to have mydnsconfig on a separate server to mydns

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)

- General (http://www.howtoforge.com/forums/forumdisplay.php?f=21)

- - How to have mydnsconfig on a separate server to mydns (http://www.howtoforge.com/forums/showthread.php?t=21641)

How to have mydnsconfig on a separate server to mydns

Hi!

Could someone give me some ideas on what I need to do to be able to have mydnsconfig running on a separate server to mydns?

As far as I can see, I think I just need to configure the mysql database on the server running mydns to allow remote access from the server running mydnsconfig?

I've tried simply creating a user:

Code:

GRANT SELECT, INSERT, UPDATE, DELETE ON mydns.* TO 'mydns'@'<server-running-mysqlconfig>' IDENTIFIED BY '<password>';

But this does not seem to be enough!

Thanks!
James.

ok try this

set the account to connect from any host
and give it full access rights to the mydns table

if it works
than cut the access rights down to what you need
than try to put in the <remoteIP>

but maybe the sqlserver is only set to listen on localhost IP address
not on the LAN IP