/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 vote117 views1 answer
Save single sql query result boolean spring boot
SQL
1 vote126 views1 answer
Find a column in all tables postgres
SQL
1 vote127 views3 answers
Union in sql
SQL
0 vote149 views1 answer
Set Mamp mysql globally
SQL
0 vote122 views1 answer
Mysql earlier than date
SQL
0 vote143 views1 answer
Template MySQL Zabbix agent
SQL
0 vote135 views2 answers
Sql query for getting details by id
SQL
4 votes145 views1 answer
List tables sqlite
SQL
0 vote152 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
1 vote140 views1 answer
Sysdate in sql
SQL