/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 vote140 views1 answer
Oracle procedure chain step
SQL
0 vote149 views1 answer
Java check if something is in mysql table
SQL
1 vote139 views1 answer
Postgres first_value in gropby
SQL
0 vote143 views1 answer
How to print records of employees hired in particular month in oracle
SQL
9 votes152 views2 answers
Oracle all tables in schema
SQL
0 vote140 views1 answer
Mysql multiple primary keys
SQL
1 vote136 views1 answer
Delete row mssql
SQL
2 votes161 views1 answer
Column names in oracle sql
SQL
0 vote205 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote139 views1 answer
What is delimiter in mysql
SQL