/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 vote345 views1 answer
Select nth row in mysql
SQL
4 votes333 views1 answer
Create table if not exist in sqlite
SQL
0 vote336 views1 answer
Alter table name including schema
SQL
1 vote370 views1 answer
Sqlalchemy order by descending
SQL
2 votes356 views2 answers
Storing timezones in postgres
SQL
0 vote341 views1 answer
Sql server python connection
SQL
2 votes392 views1 answer
Creating a view SQL
SQL
1 vote371 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote331 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote326 views1 answer
Update set with inner join oracle
SQL