/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 vote114 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote130 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote156 views1 answer
Scheduled mysql database backup in linux
SQL
0 vote118 views1 answer
Format the money fied with comma in international system using sql
SQL
9 votes125 views3 answers
Where clause sql
SQL
0 vote106 views1 answer
Selects all the columns from the sailors table
SQL
10 votes129 views4 answers
Sql server pagination
SQL
0 vote128 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote136 views1 answer
Distance calculator from lat long sql query
SQL
0 vote117 views1 answer
Python connect microsoft sql server
SQL