Create User with all Permissions

Submitted by:Jhon Smith

Date added:04 June, 2013

Category:MySQL

The below snippet will create a MySQL user and grant them all permissions on the given database.

Tags: grant permission

Code Snippet:

GRANT ALL ON `database`.* TO 'user'@'%' IDENTIFIED BY 'password';

GRANT ALL ON `database`.`table` TO 'user'@'192.168.1.%' IDENTIFIED BY 'password';
 
 

Comments