advanced code snippet search

Posted By

wearetherock on 09/14/09


Tagged

sql create user grant


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


Create New User and Grant

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. CREATE user 'username'@'localhost' IDENTIFIED BY 'password';
  2. GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'username'@'localhost';

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: wearetherock on October 2, 2009 
GRANT ALL ON foo.* TO bar@'162.54.10.20' IDENTIFIED BY 'PASSWORD';

You need to login to post a comment.