Your Ad Here

advanced code snippet search

Posted By

athome on 10/03/11


Tagged

mysql security user grant privilege


Versions (?)

Create user & grant privilege

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  1. CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'strong_password';
  2.  
  3. GRANT ALL PRIVILEGES ON db_name.* TO 'user_name'@'localhost' IDENTIFIED BY 'strong_password';
  4.  
  5. FLUSH PRIVILEGES;

Report this snippet  

You need to login to post a comment.