mysql grant delete privilege code example
Example 1: grant revoke privileges to mysql username
#in SQL execute
#GRANT type_of_permission ON database_name.table_name TO 'username'@'localhost';
GRANT ALL PRIVILEGES ON * . * TO 'username'@'localhost';
#reload all the privileges
FLUSH PRIVILEGES;
#Show Privileges
SHOW GRANTS FOR 'username'@'localhost';
#Revoke Privileges
REVOKE type_of_permission ON database_name.table_name FROM 'username'@'localhost';
Example 2: mysql grant
if(curl_exec($ch) === false)
{
echo 'Curl error: ' . curl_error($ch);
}
else
{
echo 'Operation completed without any errors';