/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 votes216 views1 answer
Force using index oracle
SQL
0 vote214 views1 answer
Mysql date time string format python
SQL
0 vote228 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
1 vote216 views1 answer
Sql eliminare un record
SQL
1 vote207 views2 answers
Postgresql list columns
SQL
0 vote205 views1 answer
Mysql select where text contains
SQL
7 votes227 views3 answers
SQL create a new table
SQL
2 votes212 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote207 views1 answer
Difference between cross apply and inner join
SQL
0 vote197 views1 answer
Oracle list chain steps
SQL