Insert User : Add User « User Permission « SQL / MySQL






  1. SQL / MySQL
  2. User Permission
  3. Add User

Insert User

 
  
USE mysql
INSERT INTO user VALUES('localhost','Joe',PASSWORD('joejoe'),'Y','Y', 
       'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');

FLUSH PRIVILEGES;

select * from user;








Related examples in the same category

1.Create a new user with full privileges
2.Creating a New Database and User
3.Confirm privileges for the new user
4.Create user for localhost