/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 vote313 views1 answer
Postgres execute multiple sql file from command line
SQL
4 votes314 views2 answers
Oracle sql group by date year
SQL
1 vote378 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote371 views1 answer
Sql query for login with email or username
SQL
0 vote315 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
2 votes315 views1 answer
Get first 2 letter in sql
SQL
8 votes324 views1 answer
Sql limit results returned
SQL
0 vote310 views1 answer
Mssql check if date is greater than today
SQL
0 vote625 views1 answer
Power bi connect to postgresql
SQL
3 votes310 views1 answer
Define REGEXP?
SQL