Description\n-----------\n\nThe RENAME USER statement renames existing MariaDB accounts. To use it, you must have the global CREATE USER privilege or the UPDATE privilege for the mysql database. Each account is named using the same format as for the CREATE USER statement; for example, 'jeffrey'@'localhost'.\\\nIf you specify only the user name part of the account name, a host name part of '%' is used.\n\nIf any of the old user accounts do not exist or any of the new user accounts already exist, ERROR 1396 (HY000) results. If an error occurs, RENAME USERwill still rename the accounts that do not result in an error.\n\nFor modifying an existing account, see ALTER USER.\n\nExamples\n--------\n\nCREATE USER 'donald', 'mickey';\nRENAME USER 'donald' TO 'duck'@'localhost', 'mickey' TO 'mouse'@'localhost';\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/rename-user