/SQL/Mysql remove user privileges

Mysql remove user privileges

Mysql delete user if exists

DROP USER IF EXISTS 'user'@'127.0.0.1' ;

3

Source: stackoverflow.com

Revokeprivileges mysql

REVOKE ALL ON dbname.* FROM 'username'@'localhost';

2

Mysql remove user privileges

REVOKE ALL PRIVILEGES ON database_name.* FROM 'username'@'host';
OR 
DROP USER 'username'@'host';

1

Similar codes

10 votes188 views1 answer
Oracle dba_dependencies
SQL
0 vote194 views1 answer
Ajouter une clé etrangere mysql
SQL
4 votes199 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote210 views1 answer
Oracle execute package dblink
SQL
23 votes193 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote192 views1 answer
Less mysql display
SQL
15 votes206 views6 answers
Laravel db transaction
SQL
1 vote195 views2 answers
Oracle create synonym
SQL
0 vote191 views1 answer
Yesql
SQL
2 votes228 views1 answer
Oracle current date without time
SQL

Share