/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

1 vote139 views1 answer
Drush sql-dump
SQL
2 votes150 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote281 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
2 votes161 views1 answer
Sql server current date minus 5 years
SQL
8 votes141 views3 answers
Alter user root mysql
SQL
0 vote158 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote163 views2 answers
List tables sqlalchemy
SQL
33 votes146 views6 answers
Change column name in mysql
SQL
0 vote148 views1 answer
Sql server size of every table in a db
SQL
0 vote149 views1 answer
How to generate ids in sql
SQL