Rename MySQL Root User

 in This Tutorial you will Learn " How To Rename MySQL Root User "
MySQL is a relational database management system based on SQL.
_________________________________________________________________________________________
Server - Os:  Rocky Linux 8.5  64Bit      |    IP -192.168.1.20        |     Hostname - www.primaryhost.com
_________________________________________________________________________________________
cat /etc/system-release
mysql -u root -p
select user,host from mysql.user;
rename user 'root'@'localhost' to 'newadmin'@'localhost';
select user,host from mysql.user;
FLUSH PRIVILEGES;
EXIT;
mysql -u newadmin -p
_________________________________________________________________________________________