/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

1 vote256 views2 answers
T-sql random number for each row
SQL
5 votes273 views1 answer
Purge undo tablespace oracle 11g
SQL
8 votes287 views2 answers
Sqlsrv default port
SQL
0 vote227 views1 answer
Connection error in mysql workbench
SQL
17 votes258 views6 answers
Sql current date
SQL
2 votes300 views2 answers
Postgresql get table names
SQL
0 vote290 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
19 votes286 views6 answers
Create table sqlite
SQL
0 vote274 views1 answer
Sql server datetime
SQL
0 vote267 views1 answer
Where case insensitive like mysql
SQL