MySQL create superuser

[zemerdon]

Create root user in Mysql
How to create a superuser in MySQL?

Code: Select all

CREATE USER 'username'@'localhost' IDENTIFIED BY 'the_password';
GRANT ALL PRIVILEGES ON *. * TO 'user_name'@'localhost' WITH GRANT OPTION;
CREATE USER 'username'@'%' IDENTIFIED BY 'the_password';
FLUSH PRIVILEGES;