Showing posts with label Create user mysql by cmd. Show all posts
Showing posts with label Create user mysql by cmd. Show all posts

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