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
Samstag, 12. Juli 2008
Abonnieren
Kommentare zum Post (Atom)
Keine Kommentare:
Kommentar veröffentlichen