/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 vote204 views1 answer
Sql eliminare un record
SQL
25 votes220 views6 answers
Import mysql database command line
SQL
0 vote197 views1 answer
Oracle search in date columns
SQL
2 votes191 views2 answers
Postgres set user as superuser
SQL
0 vote203 views2 answers
Install phoenix
SQL
-2 votes202 views3 answers
Sqlite reset autoincrement
SQL
1 vote223 views2 answers
Drop table with constraints
SQL
12 votes213 views6 answers
How to install sqlite3 in python
SQL
2 votes200 views1 answer
How to check grants on a package in oracle
SQL
0 vote218 views1 answer
Sql filter rows with condition
SQL