# Mind Candy

Tuesday, June 13, 2006

Privileges

Grants for root@localhost:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '(some password)' WITH GRANT OPTION

Grants for sguil@localhost:
GRANT FILE ON *.* TO 'sguil'@'localhost' IDENTIFIED BY PASSWORD '(some password)'
GRANT ALL PRIVILEGES ON `sguildb`.* TO 'sguil'@'localhost'

Grants for magenta@company.com:
GRANT FILE ON *.* TO 'magenta'@'company.com'
GRANT ALL PRIVILEGES ON `sguildb`.* TO 'magenta'@'company.com'

So what am I missing???

0 Comments:

Post a Comment

<< Home