Some useful MySQL commands
Grant privileges* on table: To grant SELECT, INSERT, UPDATE, and DELETE privileges on table name: data_table to a user name jdoe, you would run the following GRANT statement: GRANT SELECT, INSERT, UPDATE, DELETE ON data_table.* TO ‘jdoe’@’localhost’; *Privileges can be any of: SELECT, INSERT, UPDATE, DELETE, INDEX, CREATE, ALTER, DROP, GRANT, ALL Revoke privileges on […]