/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

3 votes170 views5 answers
Foreign keys
SQL
6 votes147 views3 answers
Oracle all dates between two dates
SQL
3 votes166 views3 answers
1396(hy00) mysql error
SQL
0 vote153 views1 answer
How to generate ids in sql
SQL
5 votes157 views1 answer
Oracle asynchronous update
SQL
2 votes167 views1 answer
Query to find table size in oracle 12c
SQL
3 votes171 views1 answer
Force using index oracle
SQL
-1 vote150 views3 answers
MySQL shutdown unexpectedly
SQL
1 vote179 views1 answer
Oracle schema size
SQL
13 votes148 views1 answer
Views in sql
SQL