In What File The Data For A MySQL Remote Profile Is Saved?

Question

In What File The Data For A MySQL Remote Profile Is Saved?

Answer

All the information for each MySQL Remote interface/profile added to the server is saved in the following JSON file: 

/var/cpanel/mysql/remote_profiles/profiles.json

And here is a sample data for demonstration: 

/usr/bin/python2.7 -m json.tool /var/cpanel/mysql/remote_profiles/profiles.json
{
    "TEST": {
        "active": 0,
        "mysql_host": "10.2.49.23",
        "mysql_pass": "3z*H/q2yP/RW,Zv%",
        "mysql_port": "3306",
        "mysql_user": "root",
        "setup_via": "Profile created via SSH"
    },
    "localhost": {
        "active": 1,
        "mysql_host": "localhost",
        "mysql_pass": "ySXct$JOdWEB",
        "mysql_port": "3306",
        "mysql_user": "root",
        "setup_via": "Auto-Migrated active profile"
    }
}