/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 vote279 views1 answer
Psql connect
SQL
0 vote262 views1 answer
Mssql check if date is greater than today
SQL
1 vote265 views1 answer
Mysql how to reset primary key
SQL
3 votes242 views1 answer
Sql cast to integer
SQL
0 vote294 views1 answer
"Hello User Name"
SQL
1 vote263 views1 answer
Oracle split string
SQL
0 vote265 views2 answers
Update query with between in mysql
SQL
0 vote279 views5 answers
Mode sql course
SQL
22 votes259 views4 answers
Tsql rename table
SQL
0 vote272 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL