/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 vote147 views1 answer
List mysql tables and views
SQL
1 vote177 views1 answer
Mysql search like order by best match
SQL
0 vote126 views0 answer
SQL
0 vote158 views1 answer
Postgresql print sessions using the database
SQL
12 votes154 views4 answers
Mysql version
SQL
2 votes152 views1 answer
Mysql sysdate - 1 day
SQL
2 votes146 views1 answer
Delete all value query
SQL
0 vote155 views1 answer
Mysql query problems and solutions
SQL
3 votes188 views2 answers
@sqlresultsetmapping
SQL
0 vote165 views1 answer
T sql dynamic top n query
SQL