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.
