/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 vote189 views1 answer
Postgres full text search example
SQL
1 vote169 views1 answer
Psql connections
SQL
1 vote183 views2 answers
Drop table if exists test
SQL
5 votes234 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
6 votes162 views2 answers
Mysql concatenate two columns into one
SQL
26 votes417 views6 answers
Modify column name in sql
SQL
3 votes158 views2 answers
Postgres download
SQL
0 vote173 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
3 votes171 views1 answer
Pl sql escape &
SQL
0 vote153 views1 answer
Materialized view redshift
SQL