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