Return remote MySQL profiles

This function displays the details of all remote MySQL® profiles available in WHM.

SecurityBasicAuth
Responses
200

HTTP Request was successful.

Response Schema: application/json
object
object
get/remote_mysql_read_profiles
Request samples
whmapi1 --output=jsonpretty \
  remote_mysql_read_profiles
Response samples
application/json
{
  • "data": {
    • "MyProfile": {
      • "active": 0,
      • "is_localhost_profile": 1,
      • "mysql_host": "192.168.0.1",
      • "mysql_pass": "123456luggage",
      • "mysql_port": 3306,
      • "mysql_user": "username",
      • "mysql_version_is_supported": 0,
      • "setup_via": "Main terminal"
      },
    • "MyProfile2": {
      • "active": 0,
      • "is_localhost_profile": "1",
      • "mysql_host": "192.168.0.2",
      • "mysql_pass": "123456luggage",
      • "mysql_port": 3306,
      • "mysql_user": "username",
      • "mysql_version_is_supported": "0",
      • "setup_via": "Main terminal"
      },
    • "localhost": {
      • "active": 1,
      • "is_localhost_profile": 1,
      • "mysql_host": "localhost",
      • "mysql_pass": "#1mpll-C",
      • "mysql_port": 3306,
      • "mysql_user": "root",
      • "mysql_version_is_supported": 0,
      • "setup_via": "Auto-Migrated active profile"
      }
    },
  • "metadata": {
    • "command": "remote_mysql_read_profiles",
    • "reason": "OK",
    • "result": 1,
    • "version": 1
    }
}