Sunday, March 2, 2008

Grant previliages to the user for a database

To Grant previliages to the user for a database always use command:
GRANT ALL PRIVILEGES ON DataBaseName.* TO DatabaseUSer@'%' IDENTIFIED BY 'PassWord';

This also enables the remote connection on the database for that user, so that you can connect to the database using a MySql client.

No comments: