You can find our user documentation at

Check out our new API beta site!

Child pages
  • WHM API 1 Functions - rename_mysql_database
Skip to end of metadata
Go to start of metadata


This function changes a MySQL® database's name.

MySQL does not allow you to rename a database. When cPanel & WHM "renames" a database, the system performs the following steps:
  1. The system creates a new database.
  2. The system moves data from the old database to the new database.
  3. The system recreates grants and stored code in the new database.
  4. The system deletes the old database and its grants.


  • If any of the first three steps fail, the system returns an error and attempts to restore the database's original state. If the restoration process fails, the API function's error response describes these additional failures.
  • In rare cases, the system creates the second database successfully, but fails to delete the old database or grants. The system treats the rename action as a success; however, the API function returns warnings that describe the failure to delete the old database or grants.


In cPanel & WHM version 76 and later, when you disable the MySQL/MariaDB role and remote MySQL is not already configured, the system disables this function.


 Command Line
whmapi1 rename_mysql_database oldname=database newname=database2 cpuser=example


  • Unless otherwise noted, you must URI-encode values.
  • For more information and additional output options, read our Guide to WHM API 1 documentation or run the whmapi1 --help command.
  • If you run CloudLinux™, you must use the full path of the whmapi1 command:


 Output (JSON)
  "metadata": {
    "version": 1,
    "reason": "OK",
    "result": "1",
    "command": "rename_mysql_database"
 Output (XML)


Use WHM's API Shell interface (WHM >> Home >> Development >> API Shell) to directly test WHM API calls.


ParameterTypeDescriptionPossible valuesExample


The database's current name.

A valid database name. database




The database's new name.

A valid database name.


  • If database prefixing is enabled, this parameter must include the database prefix for the account.
  • The maximum length of the database name is 64 characters. However, due to the method that cPanel & WHM uses to store MySQL database names, each underscore character (_) requires two characters of that limit. Therefore, if you enable database prefixing, the maximum length of the database name is 63 characters, which includes both the database prefix and the underscore character. Each additional underscore requires another two characters of that limit.



The database's owner.

A valid username.username


This function only returns metadata.


This function's metadata includes the payload_is_literal return. For more information, read our WHM API 1 - Return Data documentation.