Page tree
Skip to end of metadata
Go to start of metadata

This document is for a previous release of cPanel & WHM. To view our latest documentation, visit our Home page.

For cPanel & WHM 11.44

(Home >> SQL Services >> Additional MySQL Access Hosts)

Overview

This feature allows your users to remotely access MySQL® databases on your web server, or a remote MySQL server that you configured via WHM's Setup Remote MySQL Server interface (Home >> SQL Services >> Setup Remote MySQL Server). The system will apply this list of access hosts to every cPanel user and every MySQL user owned by a cPanel user.

Notes:

  • cPanel users cannot permanently control remote hosts that you add through this interface. cPanel account holders can temporarily remove these remote hosts via cPanel's Remote MySQL interface (Home >> Databases >> Remote MySQL). The system restores these hosts when the user accesses cPanel's MySQL Databases interface (Home >> Databases >> MySQL Database) or the system administrator click the Click Here link in the Additional MySQL Access Hosts interface.
  • cPanel account holders can add more remote hosts to their account and their MySQL users via cPanel's Remote MySQL interface (Home >> Databases >> Remote MySQL).
  • The system does not allow system accounts and root-level users that are not cPanel account holders to use this functionality.

Configure remote MySQL access

To configure remote MySQL access, perform the following steps:

  1. In the text box, enter the hostnames of remote MySQL servers that you wish for users to access.
    • You may enter hostnames as fully qualified domain names (FQDNs) or IP addresses. (For example, host.example.com or 208.77.188.166.)

      Warning:

      You must specify FQDNs in lowercase letters.

  2. Click Save.

To add the hostnames to each user's access list, perform one of the following:

  • Click Click Here! to automatically add the hostnames to each cPanel user's access list.
  • Tell your cPanel users to access the Remote MySQL interface (Home >> Databases >> Remote MySQL) to add the hosts.