/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 vote222 views1 answer
Offset in postgresql example
SQL
22 votes228 views4 answers
Date format mysql
SQL
6 votes162 views2 answers
Generate c# class from sql server table
SQL
0 vote212 views1 answer
How to select an index in oracle sql
SQL
6 votes204 views4 answers
Eloquent to sql with bindings
SQL
0 vote202 views1 answer
How to get initials in sql
SQL
0 vote213 views1 answer
Mysql database hyphen
SQL
6 votes196 views1 answer
Sqlite foreign key
SQL
0 vote201 views4 answers
Sql server date format yyyy-mm-dd
SQL
2 votes207 views1 answer
Sql to char function with date
SQL

Share