/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
Tsql table column constraint must be uppercase
SQL
0 vote127 views1 answer
Default order by in mysql
SQL
0 vote127 views1 answer
Oracle swap partition
SQL
10 votes117 views4 answers
Join with multiple conditions sql
SQL
2 votes128 views3 answers
Mysql list tables by size
SQL
0 vote133 views2 answers
Sql regex vowel
SQL
0 vote129 views1 answer
Download mysql database to excel in android studio
SQL
-1 vote134 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote138 views1 answer
Mysql custom sort order
SQL
15 votes129 views3 answers
Mysql update add to existing value
SQL