This function renames a MySQL® database user.
Important:
When you disable the MySQL role and remote MySQL is not already configured, the system disables this function.
newname required | string The user's new name. Important:To learn more about database username limits, check your database type: MySQL 5.6MySQL version 5.6 limits the database username to 16 characters. The server uses the first nine characters of this limit for the database prefix. The database prefix uses the cPanel account's username and an underscore ( For example:
MySQL 5.7+MySQL versions 5.7 and later limit the database username to 32 characters. The server uses the first nine characters of this limit for the database prefix. The database prefix uses the cPanel account's username and an underscore ( For example:
MariaDBMariaDB limits the database username to 47 characters. The server uses the first nine characters of this limit for the database prefix. The database prefix uses the cPanel account's username and an underscore ( For example:
Example: newname=mynewusername |
oldname required | string The user's current name. Example: oldname=dbuser |
apiversion | integer The version of the API. |
func | string The name of the method called. |
module | string The name of the module called. |
object |
uapi --user=username Mysql rename_user oldname='dbuser' newname='mynewusername'
{- "apiversion": 3,
- "func": "rename_user",
- "module": "Mysql",
- "result": {
- "data": null,
- "errors": null,
- "messages": null,
- "metadata": { },
- "status": 1,
- "warnings": null
}
}