Advanced Search

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