advanced code snippet search

Posted By

claudiodev on 10/22/12


Tagged

mysql sql create grant


Versions (?)

create new database

 / Published in: MySQL
 

Create a new database and its respective user with all privileges

Expand | Embed | Plain Text 
  1. CREATE DATABASE <database_name>
  2. GRANT all on <database_name>.* to <user_name>@localhost identified BY '<user_password>';

Report this snippet  

You need to login to post a comment.