/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 vote107 views1 answer
Mysql show database size in mb
SQL
0 vote98 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
1 vote109 views1 answer
Ef core 5.0 usesqlserver not found
SQL
3 votes142 views2 answers
Update part of a string in mysql
SQL
25 votes106 views6 answers
Sql update query
SQL
0 vote100 views1 answer
Oracle search columns in schema
SQL
0 vote60 views1 answer
Update sql join multiple tables
SQL
1 vote107 views1 answer
How to select random rows from a table
SQL
1 vote112 views1 answer
Sql server list locks
SQL
48 votes168 views3 answers
Psql create database
SQL