/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 votes377 views2 answers
Oracle unlock account
SQL
0 vote403 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote325 views1 answer
Oracle list all stored procedures
SQL
13 votes358 views2 answers
Sql join
SQL
6 votes353 views1 answer
Check Table Exists
SQL
1 vote367 views1 answer
Jooq convert using gbk
SQL
18 votes306 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote353 views1 answer
How to update date add hours in postgresql
SQL
0 vote408 views1 answer
Psql create usr
SQL
0 vote397 views1 answer
Oracle list datafiles
SQL