MySQL create superuser
Posted: Fri Sep 15, 2023 3:06 pm
Create root user in Mysql
How to create a superuser 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;