/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 vote317 views1 answer
Mysql replication change database name
SQL
0 vote346 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
1 vote326 views1 answer
SQLite order random
SQL
0 vote317 views1 answer
Month mysql
SQL
0 vote331 views2 answers
Athena drop partition
SQL
0 vote339 views1 answer
Sqlite3 update select
SQL
11 votes352 views5 answers
Update table from another table mysql
SQL
0 vote277 views1 answer
Testing sql queries
SQL
0 vote333 views1 answer
How to use group_concat in sql server
SQL
0 vote323 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL