Answers for "GRANT ALL ON . to "user"@"%" IDENTIFIED BY password"

grant user all privileges

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

Posted by: Guest on September-11-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 "GRANT ALL ON . to "user"@"%" IDENTIFIED BY password"