Tuesday, August 28, 2012

how to assign ip and create user in mysql

setp 1-  > CREATE USER 'bikash'@'localhost' IDENTIFIED BY 'password';

step 2--> GRANT ALL PRIVILEGES ON demo . * TO bikash@localhost IDENTIFIED BY '123456'


GRANT ALL PRIVILEGES ON bikash_db. * TO 'bikash'@'%' IDENTIFIED BY 'tt@12345';
remote access-
GRANT ALL PRIVILEGES ON *.* TO 'bikash'@'%' IDENTIFIED BY 'tt@12345';
FLUSH PRIVILEGES;

No comments:

Post a Comment