/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

1 vote265 views1 answer
Nullif postgresql
SQL
0 vote209 views1 answer
Postgres create database if not exists
SQL
9 votes253 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote242 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote239 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote229 views1 answer
Python mysql executemany
SQL
1 vote217 views1 answer
Find logged in users mysql
SQL
0 vote266 views1 answer
Sql constarint
SQL
3 votes261 views2 answers
@sqlresultsetmapping
SQL
1 vote243 views1 answer
What is int in mysql
SQL