Answers for "mysql grant user root privileges"

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@localhost identified by 'password' with grant option;

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

Posted by: Guest on August-21-2021

Code answers related to "mysql grant user root privileges"