How to RENAME USER in MariaDB

Renaming User account in MariaDB is very easy. Use below statement to rename user in MariaDB.

Syntax:

MariaDB > RENAME USER 'Old_User_Name'@'host' TO 'New_User_Name'@'Host';

Example:
Let's say that we have user 'TB' and we would like to Rename to 'TechBrothers' , we can use below statement.

MariaDB > RENAME USER 'TB'@'localhost' TO 'TechBrothers'@'localhost';