/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 vote275 views1 answer
Postgresql list extensions
SQL
3 votes246 views1 answer
Oracle apex message quit website
SQL
-1 vote251 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote245 views1 answer
C# datetime to sql server datetime
SQL
0 vote264 views1 answer
Get date from timestamp in mysql
SQL
0 vote248 views1 answer
Sum value by month sql
SQL
0 vote244 views1 answer
Deny select insert update delete sql
SQL
2 votes257 views1 answer
Sql to char function with date
SQL
8 votes278 views1 answer
Oracle add auto_increment column to existing table
SQL
1 vote259 views1 answer
Create table tablename as select * from tablename
SQL