user name mysql code example

Example 1: alter user root mysql

ALTER USER 'root'@'localhost' IDENTIFIED BY 'newPassword';

Example 2: change name of user mysql

RENAME USER old_user1 
TO new_user;