Return to Snippet

Revision: 5789
at June 30, 2008 18:42 by cbrant


Updated Code
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'PasswordHere' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'PasswordHere' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Revision: 5788
at April 4, 2008 03:52 by cbrant


Initial Code
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'PasswordHere' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'PasswordHere' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Initial URL
http://www.bytechemist.com/2008/06/30/grant-mysql-privileges/

Initial Description
To grant all privileges to a user from any location login to the mysql shell and run the following queries.

Initial Title
Grant MySQL Privileges

Initial Tags
mysql, sql, textmate

Initial Language
SQL