Monday, August 22, 2011

mysql - Create database and assign user access

create user pmuser@'localhost' identified by 'pmuser';
drop database pmdata;
create database pmdata;
grant all on pmdata.* to pmuser@'localhost';

No comments:

Post a Comment