The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Reload this Page setup of user a/c in mysql in linux
Google UNIX.COM
Forums Portal Register Rules & FAQContribute Members List Arcade Search Today's Posts Mark Forums Read



Thread: setup of user a/c in mysql in linux
View Single Post in UNIX Forums - Click on the Thread or Permalink to View Entire Thread -->
  #2 (permalink)  
Old 04-19-2007
cbkihong cbkihong is offline
Moderator
  

Join Date: Sep 2002
Location: Hong Kong, China
Posts: 1,422
Login as root mysql user, and then use the grant command, e.g.

grant all privileges on db.* to 'user'@'localhost' identified by 'password'



http://dev.mysql.com/doc/refman/5.0/...istration.html

Read sect. 5.7 and sect. 5.8.
Last edited by cbkihong; 04-19-2007 at 05:05 PM.
Reply With Quote