/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

4 votes182 views1 answer
Postgresql show current database
SQL
0 vote187 views1 answer
Mysql read row
SQL
0 vote192 views3 answers
Sql server import json
SQL
0 vote191 views1 answer
ORA-13717
SQL
0 vote200 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote191 views1 answer
Mysql terminal list table
SQL
9 votes205 views2 answers
Sql limit to 5 results
SQL
10 votes299 views4 answers
Sql server pagination
SQL
0 vote189 views1 answer
Hive batch drop table
SQL
11 votes178 views2 answers
Having clause
SQL