Child pages
  • Additional MySQL Access Hosts

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Page
LIB:_Version
LIB:_Version

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

Table of Contents
stylenone

Overview

This interface allows you to permit remote hosts (servers) to access MySQL® databases on your server, or to access a remote MySQL server that you configured via WHM's Manage MySQL Profiles interface (WHM >> Home >> SQL Services >> Setup Remote MySQL Server). The system applies this list of servers to every cPanel user and every MySQL user that a cPanel user owns.

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

Configure remote access to MySQL

To configure the list of remote hosts with access to your MySQL databases, perform the following steps:

  1. In the text box, enter the hostnames of remote hosts that you wish to access your server's MySQL databases.
    • You may enter the hostnames as fully qualified domain names (FQDNs) or IP addresses (for example, host.example.com or 192.168.0.20).

      Warning
      titleWarning:

      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 actions:

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

Additional documentation

Localtab Group


Localtab
activetrue
titleSuggested documentation

Content by Label
showLabelsfalse
max5
showSpacefalse
cqllabel in ("mysql","databases") and label = "whm" and space = currentSpace()


Localtab
titleFor cPanel users

Content by Label
showLabelsfalse
max5
showSpacefalse
cqllabel in ("mysql","databases") and label = "cpanel" and space = currentSpace()


Localtab
titleFor WHM users

Content by Label
showLabelsfalse
max5
showSpacefalse
cqllabel in ("mysql","databases") and label = "whm" and space in (currentSpace(),"CKB")


Localtab
titleFor developers

Content by Label
showLabelsfalse
max5
showSpacefalse
cqllabel in ("mysql","databases") and space = "DD"