/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 vote354 views1 answer
Create bdd mysql
SQL
2 votes368 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote345 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
11 votes356 views1 answer
Get ddl materialized view oracle
SQL
0 vote334 views1 answer
Mysql show create db
SQL
0 vote335 views1 answer
What is the use of index in mysql table
SQL
3 votes333 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote363 views1 answer
Oracle sql number to varchar2
SQL
0 vote369 views2 answers
How to count codition
SQL
16 votes324 views2 answers
Gremove folder from git
SQL