Answers for "how to create root user and grant all privileges in mysql"

mysql grant all privileges to a user

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

Posted by: Guest on March-18-2020

mysql grant all privileges on *.* to 'root'@' ' identified by

mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'PASSWORD';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

Posted by: Guest on August-31-2021

Code answers related to "how to create root user and grant all privileges in mysql"