alter user grant all privileges mysql code example
Example 1: mysql grant all privileges to a user
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';
Example 2: 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';