/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

0 vote129 views1 answer
Call function sql oracle
SQL
0 vote148 views1 answer
Top 3 salary in sql
SQL
0 vote148 views1 answer
How to display value of variable in mysql
SQL
0 vote146 views1 answer
How to put value in parameters in mysqldataadapter
SQL
10 votes144 views3 answers
Insert into auto increment mysql
SQL
0 vote96 views2 answers
Delete query sql server
SQL
9 votes143 views6 answers
Sql insert into
SQL
4 votes141 views1 answer
Mysql set max connections
SQL
2 votes137 views2 answers
Mysql all columns
SQL
0 vote166 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL

Share