I found this online, and it’s a perfect example of a bad habit I’ve been trying to clean up for some time. When I’m trying out software that needs a MySQL database, I’m used to create database foo; but not creating a specific user for that database. Sure, if it’s in the install steps it’s easy to cut and paste, but otherwise root ends up accessing everything, and just like using root in Linux, that’s not a good idea, security wise. So that’s it, I won’t be lazy with this anymore, for reference here’s how to do it, just replace DB name, username and password and you’re all set.
mysql -u root -p
create database 'DatabaseName';
grant all on 'DatabaseName'.* to 'UsersName'@'localhost' identified by 'UsersDatabasePassword';
flush privileges;
Update: thanks to ‘Bacon’ below, I’ve simplified this method from what is below - thanks!
mysql -u root -p
create database 'DatabaseName';
create user 'UsersName'@'localhost' identified by 'UsersDatabasePassword';
grant all privileges on 'DatabaseName'.* to 'UsersName';
flush privileges;
What are your lazy admin tendencies? Let me know and I’ll write up more of these clean-up diatribes.