I think this is just a dummy grant to create a user.
Even the
Code:
grant INSERT, SELECT on snort to snort@localhost;
is pointless when the next command is :
Code:
grant CREATE,INSERT, SELECT,DELETE,UPDATE on snort to snort@localhost;
If we are reffering to the same tutoral
What it actually does is:
1. create database
2. create user (dummy grant)
3. Set password for the user
4. SEt the real permissions (real grant)
when he could just do:
1. create database
2. create user and set permissions(real grant)
3. Set password for the user
I may be wrong, I just started using mysql but I think this is it.