Creating a new db on MySQL

eng pdo sw tips

The grant syntax is designed in such an arbitrary way that it's impossible to remember it properly unless you use it every day. So I write it down, hopefully once and for all, here:

# mysqladmin create dbname
# mysql dbname
mysql> GRANT ALL PRIVILEGES ON dbname.* TO enrico;

Follows a list of keywords that I'm likely to use in the future to look for this information in case if I forgot that I wrote this note:

create new database
mysqladmin create database
grant all to enrico
create mysql test database