Samstag, 12. Juli 2008

mySQL: Add user

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

*.*: user can access all databeses and tables
customer.*: user can access only customer database
customer.address: user can only access cutomer database and address table

user@localhost: the user must be a on the local host.
user : user can access from any where

Keine Kommentare: