/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 vote134 views1 answer
Add sqlite3 in lumen
SQL
7 votes143 views1 answer
Buy forge mods server hosting
SQL
1 vote150 views1 answer
Convert to hexadecimal sql
SQL
5 votes137 views1 answer
How to check nls format in oracle
SQL
0 vote141 views1 answer
Recursive query herarchical data sql server
SQL
0 vote130 views1 answer
Power bi find all ids not in other tables
SQL
0 vote162 views1 answer
MySQL get all previous date record
SQL
19 votes134 views2 answers
Mysql add column after another
SQL
0 vote128 views2 answers
Sql count number of rows after group by
SQL
2 votes181 views1 answer
Remove foreign key constraints in postgres
SQL