For cPanel & WHM 11.46
(Home >> SQL Services >> Additional MySQL Access Hosts)
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.
- 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:
- 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,
You must specify FQDNs in lowercase letters.
- 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.