Wednesday, October 13, 2010

Mysql create user and Grant permission

CREATE USER 'visli'@'localhost' IDENTIFIED BY '123456';

GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'visli'@'localhost';
GRANT ALL ON *.* TO 'visli'@'localhost';

No comments: