KwCheng's blog

First , we must connect to database by using root account.

# mysql -u root -p

Then , we can create a new account for other people.

mysql> grant all privileges on Mydb.* to user01@localhost IDENTIFIED BY '12345678' ; 

(The account is user01 , and his sceret code is 12345678 , he have all privileges for Mydb database)

ref : http://www.sy3es.tnc.edu.tw/teaching/php_mysql/mysql-begin.htm