/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 vote161 views3 answers
Rename table snowflake
SQL
2 votes182 views1 answer
Use cases condition in sql query laravel
SQL
1 vote182 views3 answers
Date_add mysql
SQL
0 vote183 views1 answer
Mysql where sum > 0
SQL
6 votes177 views2 answers
Sql sequence
SQL
0 vote183 views1 answer
Report in database
SQL
4 votes175 views1 answer
Postgresql list sequences
SQL
2 votes163 views2 answers
Postgresql date at timezone
SQL
0 vote165 views1 answer
Knex last insert id mysql
SQL
11 votes170 views1 answer
Oracle view ddl
SQL