Monday, November 14, 2011

Create user mysql by cmd

1. CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
2. GRANT ALL PRIVILEGES ON databasename.* TO 'monty'@'localhost;
3.FLUSH PRIVILEGES;

 > create database marketpro CHARACTER SET utf8 COLLATE utf8_general_ci;

Nguyen Si Nhan

No comments:

Post a Comment

Thanks for your join,we will be reply to you asap.