How To Create a User and Grant Permissions in MySQL
How to create a user
|
|
How to delete a user
|
|
How to grant permissions
|
|
How to apply those permissions
|
|
Going a bit deeper
Different types of Grants
ALL PRIVILEGES
: Full access to everything, globally unless restricted to a database
CREATE
: Create databases and tables
DROP
: Delete databases and tables
DELETE
: Delete rows from tables
INSERT
: Insert rows in tables
SELECT
: Read data from tables
UPDATE
: Update rows in tables
GRANT OPTION
: Grant or remote other user’s permissions
How to use them
|
|
How to revoke them
|
|
How to show them
|
|