/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 vote167 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote151 views1 answer
Sql datediff db2
SQL
0 vote200 views1 answer
Count column of tables psql
SQL
0 vote686 views1 answer
Sql show table name in result
SQL
2 votes192 views1 answer
Mysql shell insert into
SQL
3 votes168 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote146 views1 answer
Sql string length postgresql
SQL
0 vote172 views1 answer
Show table structure mysql console
SQL
0 vote153 views1 answer
How to check xampp mysql password
SQL
7 votes171 views5 answers
Max 3 salary in sql
SQL