Pages

Friday, September 26, 2014

create user mysql

create user mysql

How to create a User in MySQL ?

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
 
Next is How can we set privileges for the User for a particular database ?
 
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
 
FLUSH PRIVILEGES;
 


Solution:
 
https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql 
 

No comments:

Post a Comment