How do you create a MySQL user that can be connected to remotely using the cPanel interface?

Introduction

How do you create a MySQL user that can be connected to remotely using the cPanel interface?

Procedure

1. Log into the cPanel interface with your cPanel account username and password.

2. Navigate to the following location:

cPanel: Home -> Databases -> Remote MySQL

3. Add the IP address of allowed MySQL server to connect to your databases.

4. Click the 'Add Host' button.

This will convert all MySQL users in the account to be reachable by the IP address.

Example:

# mysql -e "select user,host from mysql.user where user like '%cptest%';"
+-------------------+-------------------------+
| user | host |
+-------------------+-------------------------+
| cptest | 10.2.32.216 | <-- added from interface
| cptest_cptest | 10.2.32.216 |<-- added from interface
| cptest_wp | 10.2.32.216 |<-- added from interface
| cptest | testserver.cptest-2.com | 
| cptest_cptest | testserver.cptest-2.com |
| cptest_wp | testserver.cptest-2.com |
| cptest | localhost |
| cptest_cptest | localhost |
| cptest_wp | localhost |
+-------------------+-------------------------+

That's it.