/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

5 votes345 views4 answers
Restart the psql server windows
SQL
13 votes308 views3 answers
Sql online code
SQL
12 votes338 views3 answers
Install sqlite driver ubuntu
SQL
5 votes324 views2 answers
Oracle rename table
SQL
2 votes319 views1 answer
Drop table purge
SQL
0 vote344 views1 answer
In query in sql
SQL
0 vote375 views1 answer
Array aggre distinct postgres
SQL
2 votes347 views5 answers
Install postgresql 10 centos 7
SQL
1 vote311 views1 answer
Display total number of tables in mysql
SQL
0 vote333 views1 answer
How to set sql_mode for a query in CI model
SQL