Create user & grant privilege


/ Published in: MySQL
Save to your folder(s)



Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.