/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 vote267 views1 answer
How to find unique key in sql
SQL
0 vote299 views1 answer
Shrink database file in sql server
SQL
0 vote288 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote268 views1 answer
Min and max salary and name in sql
SQL
0 vote292 views1 answer
Store case result sql
SQL
0 vote273 views1 answer
Login phpmyadmin without password
SQL
0 vote298 views1 answer
Dump only data
SQL
2 votes344 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote327 views3 answers
Mysql CAST(amount as float)
SQL
7 votes254 views2 answers
Create index mysql
SQL