Creating a New Database and User : Add User « User Permission « SQL / MySQL






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

Creating a New Database and User

      

CREATE DATABASE forum;

GRANT All ON forum.* TO forumadmin@localhost IDENTIFIED BY 'xxx'

drop database forum;








Related examples in the same category

1.Insert User
2.Create a new user with full privileges
3.Confirm privileges for the new user
4.Create user for localhost