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

Empowering the Future of API Management: Unveiling the Journey of WSO2 API Platform for Kubernetes (APK) Project and the Anticipated Alpha Release

  Introduction In the ever-evolving realm of API management, our journey embarked on the APK project eight months ago, and now, with great a...