/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

3 votes110 views1 answer
Two select sql
SQL
23 votes108 views5 answers
Sql substring
SQL
4 votes119 views1 answer
Adding data to table in sql python
SQL
0 vote162 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote111 views1 answer
Mysql events not work
SQL
22 votes105 views3 answers
Join three tables sql
SQL
0 vote116 views1 answer
Firebird where
SQL
34 votes123 views6 answers
Install mysql client ubuntu
SQL
1 vote127 views2 answers
Drop table with constraints
SQL
1 vote104 views1 answer
Sqlite create index
SQL