Search This Blog

Wednesday, May 8

How to Create User With all Privileges in MySQL from the command line

Create user with all privileges in MySQL


CREATE USER '<username>'@'localhost' IDENTIFIED VIA mysql_native_password USING '***';GRANT ALL PRIVILEGES ON *.* TO '<username>'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;GRANT ALL PRIVILEGES ON `<username>\_%`.* TO '<username>'@'localhost';


User the above command for Create User With all Privileges from the command line


No comments:

Post a Comment