/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 vote241 views1 answer
Oracle show running job
SQL
1 vote224 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote209 views1 answer
Column ' ' in field list is ambiguous
SQL
7 votes181 views1 answer
Safe mode mysql
SQL
0 vote216 views1 answer
Hex string sql becomes int64
SQL
0 vote185 views1 answer
Mysql money value
SQL
1 vote199 views1 answer
What is in condition in sql
SQL
5 votes198 views3 answers
Sql make column nullable
SQL
1 vote251 views1 answer
Sql server locks
SQL
0 vote221 views1 answer
Neo4j command to run script file
SQL