Databases
Remote MySQL Databases
Return remote MySQL profiles
This function displays the details of all remote MySQL® profiles available in WHM.
get/remote_mysql_read_profiles
Response
HTTP Request was successful.
Example response
{
"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
}
}