Administration Commands

Grant database privileges for a user

GRANT ALL ON example_database.* TO 'example_user'@'%' WITH GRANT OPTION;

Disable primary key requirement

SET GLOBAL sql_require_primary_key = 0;

Error debugging:

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

Revision #3
Created 4 December 2024 17:00:35 by Ahmad
Updated 4 December 2024 17:21:06 by Ahmad