/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 vote350 views1 answer
Find size of all DB's postgres
SQL
12 votes332 views4 answers
How to check mysql version ubuntu
SQL
3 votes314 views2 answers
Postgres alter table owner
SQL
0 vote282 views2 answers
Sql query unique
SQL
0 vote333 views1 answer
How do you insert boolean to postgresql
SQL
1 vote297 views1 answer
Sql server update column based on another table
SQL
0 vote308 views1 answer
Mysql date format unix timestamp
SQL
2 votes330 views1 answer
Mysql create user with remote access
SQL
6 votes301 views1 answer
What is where clause in sql
SQL
1 vote282 views1 answer
Autocommit mysql
SQL