Thursday, October 14, 2010

How to create mysql database with all permissions to users

This command can use to  grant all permissions to given user for given database at given host. So you can easili change capitalized fields and use it
mysql> grant all privileges on DATABASENAME.* to "USERNAME"@"HOSTNAME" identified by 'PASSWORD';
mysql> grant all on DATABASENAME.* to "USERNAME"@"HOSTNAME" identified by 'PASSWORD';

Next command can use to grant all permissions to all users at given host here "% " sign denotes all
mysql> grant all privileges on DBNAME.* to "%"@"HOSTNAME" identified by 'PASSWORD';

No comments:

Post a Comment