/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 vote409 views1 answer
Sql show founctions
SQL
1 vote371 views1 answer
Psql connect
SQL
0 vote350 views1 answer
Drop procedure sql
SQL
4 votes367 views2 answers
Oracle default date format
SQL
0 vote366 views1 answer
How to install postgresql on wsl
SQL
0 vote354 views1 answer
Oracle archivelog usage
SQL
1 vote375 views2 answers
Mysql trim spaces
SQL
2 votes347 views1 answer
Mariadb JSON_EXTRACT
SQL
1 vote378 views1 answer
Set id count mysql
SQL
0 vote343 views3 answers
Sql select statements
SQL