Monday, April 2, 2012

Generic mysql database creation

 GRANT USAGE ON *.* TO database_a;  
 DROP USER database_a;  
 CREATE USER database_a IDENTIFIED BY 'password';  
 DROP DATABASE IF EXISTS database;  
 CREATE DATABASE database COLLATE utf8_general_ci;  
 GRANT ALL PRIVILEGES ON database.* TO database_a IDENTIFIED BY 'password';  
 FLUSH PRIVILEGES;  
 USE database;  

No comments:

Post a Comment