This function displays the details of all remote MySQL® profiles available in WHM.
HTTP Request was successful.
object | |
object |
whmapi1 --output=jsonpretty \ remote_mysql_read_profiles
{- "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
}
}