/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 vote109 views1 answer
Create bakupd database sqlserver
SQL
0 vote137 views1 answer
Postgres in operator with comma separated values
SQL
0 vote136 views1 answer
Select multiple row from primary key sql
SQL
0 vote133 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote132 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
2 votes136 views2 answers
Storing timezones in postgres
SQL
0 vote110 views1 answer
Mariadb set vertical output format
SQL
1 vote124 views3 answers
Mariadb add foreign key
SQL
0 vote119 views1 answer
Call procedure in wordpress
SQL
0 vote132 views1 answer
Pagination with row_number
SQL