Posted By

athome on 10/03/11


Tagged

mysql security user grant privilege


Versions (?)

Create user & grant privilege


 / Published in: MySQL
 

  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.