close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 JerryCheng 的頭像
    JerryCheng

    KwCheng's blog

    JerryCheng 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄