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 Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



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

Join Date: Sep 2002
Location: Hong Kong, China
Posts: 1,624
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 09:05 PM..