Home  »  CodeSnippets   »   MySQL Grant all Privileges to a User

MySQL Grant all Privileges to a User

Posted: February 8, 2022 | by Michael Bright

Run this in your MySQL client:

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

Found this article interesting? Follow Brightwhiz on Facebook, Twitter, and YouTube to read and watch more content we post.