User Permission MySQL

  1. Home
  2. MySQL
  3. User Permission
  4. 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';