Index ¦ Archives ¦ RSS

title 39

Estimated read time: 1 minutes

i always forgot how to grant full access to a db for a normal user in mysql and have to rtfm from time to time. so i post here the magic command, hopefully it’ll be a bit easier to search in the blog archive than rtfm’ing :)

GRANT ALL privileges on dbname.* TO 'username'@'localhost' IDENTIFIED BY 'secret';

© Miklos Vajna. Built using Pelican. Theme by Giulio Fidente on github.