在沒有工具的時候怎樣用命令創(chuàng)建mysql用戶和把用戶授權(quán)給對應的數(shù)據(jù)庫.

>create database db_name;

>create user ‘user_name'@'localhost’ identified by ‘password’;

>grant all privileges on db_name.* to ‘user_name’@’localhost’;

>flush privileges;

>exit;

刪除用戶和數(shù)據(jù)庫:

>drop user user_name@localhost;                                       

>delete database db_name;