Remote MySQL Hosts
Remote MySQL Hosts lists every host that hosting accounts have allowed to reach their databases from outside the server, across all accounts. Use it to review who opened what, and to revoke an entry you do not want to keep.
Overview
URL: /admin/remote-mysql-hosts
The page sits in the Database navigation group. Rows are only ever created by account owners on their Remote MySQL page, so there is nothing to add here.
The list
| Column | Meaning |
|---|---|
| Account | The hosting account that allowed the host. |
| Allowed host | The address, range, or pattern. A % entry, meaning any host, is highlighted. |
| Description | The label the account owner gave it. |
| Added | When the entry was created. |
The list is sorted newest first, and can be searched by account, host, or description. The Any host (%) only filter narrows it to the wildcard entries, which is the fastest way to audit the server after turning the wildcard policy off in Remote MySQL Settings.
Revoke
Revoke on a row, or Revoke selected for several at once, removes database access from that host immediately. The database permissions are dropped and the firewall opening is removed, unless another account still allows the same host, in which case the opening stays for that account.
Revoking is not a warning to the customer: connections from that host stop working at once. Tell the account owner what changed, or ask them to remove the entry themselves.
Related pages
- Remote MySQL Settings - the server-wide wildcard policy.
- Client Remote MySQL - the account owner's view.
- Hosting Plans - which plans expose the feature.