create a user with root privileges mysql code example
Example 1: alter user root mysql
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newPassword';
Example 2: create mysql user with privileges
GRANT type_of_permission ON database_name.table_name TO ‘username’@'localhost’;