advanced code snippet search

Posted By

cbrant on 04/04/08


Tagged

mysql sql textmate privileges grant


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

cbrant
wumbrath
level09


Grant MySQL Privileges

 / Published in: SQL
 

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

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

Expand | Embed | Plain Text 
  1. GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'PasswordHere' WITH GRANT OPTION;
  2. GRANT ALL PRIVILEGES ON *.* TO username@"%" IDENTIFIED BY 'PasswordHere' WITH GRANT OPTION;
  3. FLUSH PRIVILEGES;

Report this snippet  

You need to login to post a comment.