Users and Privileges in MySQL #shorts

To grant MySQL privileges on MySQL Server or MariaDB, make use of the GRANT SQL statement.
The SQL query for mysql grant privileges looks like this:
GRANT privilege_type ON database_name.table_name TO 'username'@'host';

Where the privilege type is SELECT, INSERT, UPDATE, DELETE, or ALL PRIVILEGES, database_name and table_name are your database and table names, and the username and the host name are your username and the host names.

To revoke a privilege inside MySQL, issue a REVOKE SQL query:
REVOKE privilege_type ON database.table FROM 'username'@'host';

To see what database privileges are assigned to a specific user within MySQL or MariaDB, issue a SHOW GRANTS SQL query:
SHOW GRANTS FOR 'user'@'host';

#shorts #reels #database #coding #mysql #mariadb #webdevelopment

Видео Users and Privileges in MySQL #shorts канала Database Dive