View Single Post
  #2  
Old 22nd May 2005, 19:44
peter peter is offline
Junior Member
 
Join Date: May 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can use MySQL's GRANT command:

Code:
GRANT ALL PRIVILEGES ON test_db.* TO 'test_db_user'@'localhost';
GRANT ALL PRIVILEGES ON test_db.* TO 'test_db_user'@'%';
GRANT ALL PRIVILEGES ON test_db.* TO 'test_db_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON test_db.* TO 'test_db_user'@'%' IDENTIFIED BY 'password';
You can find details about it here: http://dev.mysql.com/doc/mysql/en/grant.html

Peter
Reply With Quote