/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

2 votes236 views1 answer
Dbms transaction (psql)
SQL
0 vote218 views1 answer
How to check which table has data in mysql
SQL
1 vote286 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote207 views1 answer
Postgresql auto increment not working
SQL
0 vote154 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote156 views1 answer
Sql count how many times a value appears
SQL
0 vote276 views1 answer
Generate random & unique mysql string
SQL
0 vote208 views1 answer
How to check replication lag in mySQL
SQL
0 vote224 views1 answer
How to get data from 2 database
SQL
0 vote310 views1 answer
Sql server query all database objects
SQL