After creating user. Privileges are granter to user to access specific database or to access all databases in mysql
GRANT ALL will give all privileges to user
To Grant All privileges to user following query is used
1 | GRANT ALL PRIVILEGES ON *.* TO 'manish'@'localhost' WITH GRANT OPTION; |
To provide all privileges on specific database following query is used
1 | GRANT ALL PRIVILEGES ON DatabaseName.* TO 'manish'@'localhost' WITH GRANT OPTION; |
To provide all privileges on specific tabel following query is used
1 | GRANT ALL PRIVILEGES ON DatabaseName.table1 TO 'manish'@'localhost' WITH GRANT OPTION; |