Manage MySQL® Profiles

This feature allows you to create and manage MySQL profiles. A MySQL profile defines the connection information for a local or remote MySQL server. A remote MySQL server can be useful for high traffic hosts or servers with large databases because it allows you to offload MySQL-related work.

After you configure the remote server, you must manually transfer your existing MySQL data and configure your accounts’ applications to use the remote database server.

Add Profile

Information:
  • Make certain that the MySQL server can resolve the cPanel & WHM server’s IP address to its fully-qualified hostname.
  • Do not use the skip-name-resolve option in any server’s MySQL configuration. This option may create problems on remote MySQL servers, during account transfers and restorations, and with phpMyAdmin.
  • We only support MySQL version 5.7 and 8.0 on Amazon RDS servers. We don’t support AuroraDB on Amazon RDS servers. For more information, read our documentation.
  • When using Amazon RDS, you must set the database username to root. Using any other username will cause some features in cPanel & WHM to not function properly.

Profile Settings

  • Profile names must be no more than 32 characters.
  • This field is required.
  • A profile name must begin with a letter and may only contain letters, numbers, underscores, hyphens, or spaces.

Host Settings

  • This field is required.
  • This field is required.

Login Information

  • This field is required.
  • A username must not begin with a period or number and may only contain letters, numbers, underscores, hyphens, or periods.

You have no SSH keys configured on your server. You can add an SSH key through the Manage Root’s SSH Keys interface.

  • This field is required.
Cancel

Interface Analytics

cPanel, L.L.C. uses Interface Analytics to help us understand how our customers use cPanel & WHM. We take your privacy very seriously, and you can stop data collection at any time. Find out more about Interface Analytics.

Will you allow Interface Analytics data collection for your account?