Thursday, July 15, 2010

Grant Mysql Database access...

Today morning i was just looking around for a mysql query which grants me access to another database....



GRANT ALL PRIVILEGES ON dbname.* TO 'dbname'@'urpartnerip'    IDENTIFIED BY 'dbname' WITH GRANT OPTION;
GRANT SELECT ON mysql.proc TO 'dbname'@'urpartnerip' IDENTIFIED BY 'dbname'

No comments:

Post a Comment