Sunday, October 9, 2011

MySql Create DB and Assign Privilages

Mysql:
-----------
CREATE DATABASE ram_db;

CREATE USER 'ram'@'localhost' IDENTIFIED BY '1q2w3e4r';

GRANT ALL PRIVILEGES ON *.* TO 'ram'@'localhost'

GRANT ALL PRIVILEGES ON blossom.* TO 'ram'@'localhost' IDENTIFIED BY '1q2w3e4r';

No comments:

Post a Comment