/SQL/Grant revoke privileges to mysql username

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';

Similar codes

0 vote183 views1 answer
Postgres statistics
SQL
0 vote197 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
4 votes180 views1 answer
Oracle delete last row
SQL
0 vote185 views1 answer
Alter table add check constraint oracle
SQL
0 vote178 views1 answer
Mysql find non alphanumeric characters
SQL
1 vote193 views1 answer
Oracle sql first day of year
SQL
0 vote188 views1 answer
Oracle procedure teamplate
SQL
0 vote196 views1 answer
Setval postgres example table id
SQL
1 vote167 views1 answer
Login to database mysql terminal
SQL
3 votes176 views1 answer
Postgres kill running query
SQL