/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 vote194 views1 answer
Second Step in installing SQL workbench
SQL
0 vote187 views1 answer
Update and keep original value sql
SQL
2 votes175 views1 answer
Set column to not null mysql
SQL
1 vote213 views2 answers
Full join
SQL
0 vote188 views1 answer
Mysql last 6 months
SQL
0 vote178 views1 answer
Oracle free up space in tablespace
SQL
3 votes184 views2 answers
Oracle apex charging debug
SQL
5 votes195 views1 answer
Get table columns from sql
SQL
0 vote193 views1 answer
Datagrip execute procedure
SQL
0 vote180 views1 answer
Syntax for changing column size in mysql
SQL