Mega Code Archive

 

Categories / MySQL / User Permission

 

Set up a new sample database administrator account with a username of sampadm and a password of secret

% mysql -p -u root  Enter password: ****** mysql> GRANT ALL ON sampdb.* TO 'sampadm'@'localhost' IDENTIFIED BY 'secret';