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