Please note if you are registering remote MySQL server which is not on the same box with DNP Server application your customers will not be able to do backups of their databases.
- Internal Address - Specify the name of MySQL server. By default it is "localhost", but you can use IP address too. Specify the TCP port listening by MySQL server.
- External Address - Specify "Public IP address" value for the SQL Server instance. This IP address will be used by Web Applications Installer (in the connection strings) and can be shown in space summary letter.
- MySQL Installation Folder - Specify MySQL installation folder. This path is required by DNP to access "mysqldump" utility for producing database backups.
- Root Login and Root Password - Specify root login and password to access MySQL Server.
- Database Browser Logon URL, Method and Parameters: These fields were introduced for MS SQL server with MyLittleAdmin, however they can be used with any MySQL management application if it supports auto-logon feature. The basic idea is to place a link against some database record with autologin URL (where username and password are passing through URL to login page). phpMyAdmin does not support auto-logon feature out-of-the-box, but if you know PHP you could do modifications to phpMyAdmin to support it.
Parameters field should look like this:
parameter1=value1
parameter2=value2
parameter3=value3
The following substitutions variables are supported:
[server] - "Internal Address" of MySQL server;
[user] - mysql username that has access to this mysql database
[password] - mysql password
For example:
Server=[server]
Username=[user]
Password=[password]
would give you the followinf login URL with GET method: ?Server=[server]&Username=[user]&Password=[password]
DNS Records
Verify/change MySQL Server DNS record and its data (IP address). This DNS "A" record will be added to all created DNS customer zones and it allows customer to access MySQL Server by using not only IP address, but the domain name too (e.g. sql.mydomain.com).